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