How to Create Snapshot Replication in SQL Server - SQL Server 2016 DBA Tutorial

Scenario:

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

Solution:

Video demo explains all the important points those are required to perform Snapshot Replication in SQL Server 2016. Demo covers


  • What is Snapshot Replication in SQL Server
  • When you use Snapshot Replication
  • What are the reasons we need to use Snapshot Replication
  • How Snapshot Replication works
  • What are Snapshot Agent, Distribution Agent and Merge Agent
  • Go through Security Best Practices for Snapshot Replicaiton Setup
  • How to use Replication Monitor in SQL Server
  • How to use Replication Monitor in SQL Server for Snapshot Replication


How to setup Snapshot Replication in SQL Server 2016