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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-09-12 : 10:00:34
|
| Hi,we've DB server located at US, most of the clients are in india they are complaining its slow.So we planned to do replication of data from US server to India Server(New)only for acessing. Please tell me how to replicate the server from main server to India server or suggest me the sites that can guide how to follow up with these process.Please do as earliest. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-12 : 10:08:03
|
| Look at Peer-to-Peer Replication . |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-09-29 : 11:54:36
|
| Before Replication setup, check for these things:1) network speed2) Amount of data to be replicated3) SLA - Acceptable delay on destination serverAfter this test using a simple scenario to find out existing bottlenecks at different level. No doubt you can replicate data but distance between two servers, database design, Hardware resources and network speed matters a lot in these decisions. Try other data transfer methods as well. |
|
|
|
|
|
|
DB replication