SQL Server Performance

Replication suggestion

Discussion in 'SQL Server 2005 Replication' started by gujsa01, Apr 18, 2007.

  1. gujsa01 New Member

    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.
  2. ndinakar Member

    YEs, check out Peer-Peer Replication. Books On Line has very good documentation on it.

    Dinakar Nethi
    SQL Server MVP
  3. MohammedU New Member

  4. gujsa01 New Member

    Appreciate your response!! Thanks.

Share This Page