Steve Bishop <st****@viper.com> wrote in message news:<41**********************@news.newsgroups.ws> ...
How would I set up secure replication between 2 servers that are in
different cities?
Would I need to define linked servers first?
Would I use SSL?
Help appreciated. Thanks.
Steve
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
One approach would be to set up a VPN, which would avoid exposing your
MSSQL servers directly to the internet and secure the data as it's
transferred. Your replication implementation is probably a bigger
issue than the VPN, however - you should probably review the Books
Online information on replication to see which type is most suitable
for your needs first.
Replication is quite a big topic, so you might get better answers in
microsoft.public.sqlserver.replication.
Simon