Peer to peer replication allows performing insert, update & delete against any node participating in the topology, so there may be chances of conflict if same data gets changes at different nodes at the same time.

Conflict detection was not available in SQL server 2005, it was introduced with SQL server 2008.


Part 1 : Introduction to Replication
[ Ссылка ]

Part 2 : Snapshot Replication
[ Ссылка ]

Part 3 : Transactional Replication
[ Ссылка ]

How to take a Backup in SQL server
[ Ссылка ]

Restore database in SQL server
[ Ссылка ]

свернуть