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?

Check sql server 2005 peer to peer replication…
Read on of the best article By Dinesh Asanka SQL Server 2005 Books Online
Peer-to-Peer Transactional Replication SQL Server 2005 Books Online
How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio)
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