Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-18 : 09:05:58
|
| Hitesh writes "Hi,I neeed to know if it is possible to connect 2 SQL Server systems which are not on the same LAN, but at 2 physically different locations. Each of these two computers has a modem and runs SQL Server 2000 on a Windows 2000 platform.. If yes, then how would I be able to connect the 2 SQL Servers such that they are able to replicate data.Is it possible to dial in from one computer to the other and make the servers replicate data.Please guide and assist me, since I need to suggest a solution to a prospective client.Thank you.Regards,Hitesh Sadarangani." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-18 : 13:12:56
|
| Replication over a modem? Have you ever tested this out on the same LAN to see the performance? I would bet that performance is going to be so bad that you wouldn't even want to implement this solution.Tara |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-18 : 17:44:32
|
| How much data do you have to transfer and how often?What kind of modem speed are we talking about? |
|
|
|
|
|
|
Remote SQL Server Connection