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:

1. Creating the publication and adding articles to the publication on Server 1.
2. Creating the subscription and then pushing the subscription agent (distribution agent) on Server 1.
3. Taking the backup of the AdventureWorks database on Server 1. Unlike standard transactional...