Configuring Peer-To-Peer Transactional Replication
In this section, we'll configure peer-to-peer transactional replication. The topology is as follows:

Figure 2.37: P2P Replication example
The preceding diagram illustrates peer-to-peer topology with two nodes with a push subscription:
- There isn't any additional replication agent involved.
- Each server acts as a publisher and subscriber.
- The log reader agent picks up the transactions from AdventureWorks and inserts them into the distribution database. The push subscription agent (distribution agent) pushes the transactions to the Server 2 AdventureWorks database.
Configuring P2P replication consists of the following steps:
- Creating the publication and adding articles to the publication on Server 1.
- Creating the subscription and then pushing the subscription agent (distribution agent) on Server 1.
- Taking the backup of the AdventureWorks database on Server 1. Unlike standard transactional...