SQL Server Performance

New to Replication

Discussion in 'SQL Server 2005 Replication' started by JohnLan, Jan 31, 2007.

  1. JohnLan New Member

    Hi

    does anyone have any suggestions as to what would be the recommended replication solution to this problem:

    A windows SQL Server 2005 database, that is replicated worlwide over regional offices (ie New York, London, Hong Jong etc.).

    All users are updating the same data.

    The topology should be able to handle one site going down.

    The data should be as current as possible.

    any suggestions?
    thanks
  2. MohammedU New Member

    Check sql server 2005 peer to peer replication...


    Read on of the best article By Dinesh Asanka
    http://www.sql-server-performance.com/da_peer-to-peer_replication.asp

    SQL Server 2005 Books Online
    Peer-to-Peer Transactional Replication
    http://msdn2.microsoft.com/en-US/library/ms151196.aspx

    SQL Server 2005 Books Online
    How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio)
    http://msdn2.microsoft.com/en-us/library/ms152536.aspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. dineshasanka Moderator

    yes you should use peer-2-peer replication, but you need to have SQL Server 2005 Enterprise edition

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page