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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2005-05-26 : 11:55:28
|
| Our company need to synchrinize two sql servers. One is remote the another is local. Main app will connect to remote server. If I build up replication with these two server, will slown down the performance in remote server? Any good software to do the synchrinization job? |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-05-26 : 12:21:25
|
| SQL can do it for sure. A lot will come down to the line that connects the two servers. |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-27 : 09:34:41
|
| :-) Here, from Main App you are connecting to Remote server and same time you are synchronizing data from remote server to local server.Question is, if remote and local servers are synchronized what is the point you need connect to remote server?It is all depends on your synchronize process that how offen you are doing. like nightly process OR for every one hour OR Once in a week OR once in a month.Dont go for 3rd party sync tools. Choose DTS / Replication for synchrnize the 2 servers.Keep in mind that, in day time dont synchronize the servers. Only off-peak times, no users OR Less employees connected to servers then do sync process (might be nightly process is good.)SQL Server 2000 will dynamically allocate the memory for its process. So dont worry about performance of remote server. With RegardsSreenivas Reddy B |
|
|
|
|
|
|
replication performance