Hi , We are designing 2 data centers for distributing applications between East and West coast users. I would like to Load balance one of our application between the 2 data centers. Both the data centers should be able to view/modify changes for this application. In other words if Data center 1 makes the change(s), they should be available to Data Center 2 and vice versa ONLINE. Could I get some help in understanding if Replication can provide solution to this ?? Appreciate your help and thanks in advance.
YEs, check out Peer-Peer Replication. Books On Line has very good documentation on it. *********************** Dinakar Nethi SQL Server MVP *********************** http://weblogs.sqlteam.com/dinakar/
Peer to peer replication is available only sql server 2005 EE and make you have dedicated line between two centers to reduce the latency.... Check the following articles... http://www.sql-server-performance.com/da_peer-to-peer_replication.asp http://msdn2.microsoft.com/en-us/library/ms151196.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
