Chapter 2
Transactional Replication
Section 3
Understanding Peer-to-Peer Replication
Peer-to-Peer replication, also referred to as master-master replication, is built upon transactional replication in which changes at the subscriber are also replicated to the publisher. A peer-to-peer topology consists of two or more databases where a change in each node (database) gets replicated at every other node (database) in the topology. Peer-to-peer replication therefore provides a scalable high availability solution In this section you will learn to do the following: - Creating the Publication, Adding Articles, Adding Subscription and Pushing the Subscription Agent to the Publication on Server 1 - Taking the Backup of the Publication Database on Server 1 - Restoring the Database on the Subscriber Server - Creating the Publication, Adding Articles, Adding Subscription and Pushing the Subscription Agent to the Publication on Server 2 - Verifying the Replication