Connection to remote sql server db

Hi,
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve

Connection to remote sql server db

Hi,
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan
"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve