New to Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

New to Replication

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
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
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/
]]>