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
AdventureWorksand inserts them into the distribution database. The push subscription agent (distribution agent) pushes the transactions to the Server 2AdventureWorksdatabase.
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
AdventureWorksdatabase on Server 1. Unlike standard transactional replication, P2P transactional replication is initialized using...