Microsoft® SQL Server 2012 Unleashed

Peer-to-Peer Replication

For data distribution requirements that must have updates in multiple nodes, peer-to-peer replication is ideal. You must worry about conflicts, but typically they are rare and very easily handled by a simple conflict handler. Peer-to-peer replication is transactional replication based and can have any number of peers. A separate wizard is used to set up peer-to-peer replication because of its unique characteristics. Remember, there are essentially no subscribers, just publishers. All peers are handled by one or more distributors and are assigned a unique peer originator ID value to help in transactional consistency and conflict resolution. If you have been doing replication since the SQL Server 6.5 days, the peer-to-peer ...