How to Setup Peer To Peer Replication in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA. You are asked to setup Peer to Peer replication in SQL Server 2016. What steps you will follow to perform Peer to Peer Replication in SQL Server?


Solution:

As per Microsoft here is the definition
Peer-to-peer replication provides a scale-out and high-availability solution by maintaining copies of data across multiple server instances, also referred to as nodes. Built on the foundation of transactional replication, peer-to-peer replication propagates transactionally consistent changes in near real-time. This enables applications that require scale-out of read operations to distribute the reads from clients across multiple nodes. Because data is maintained across the nodes in near real-time, peer-to-peer replication provides data redundancy, which increases the availability of data.

In this video you will learn below items
How to setup Peer to Peer Replication in SQL Server 2016

In this video you will learn
1) Identifying databases to replicate
2) Synchronizing replication databases on all nodes
3) If changes happens after sync , taking backup again for the setup
4) All nodes are distributor or separate distributor
5) What is publisher, subscriber and distributor in Peer to Peer replication
6) What are steps to setup Peer to Peer Replication in SQL server 2016


Video Demo: Step by Step setup of Peer to Peer Replication in SQL Server 2016