sql server connect: Connection to remote sql server db -- sql server connect

Connection to remote sql server db

shan
2/27/2005 3:23:03 PM

sql server connect:

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

Re: Connection to remote sql server db

Steve Thompson
2/28/2005 10:05:48 AM

[quoted text, click to view]

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