SQL Server DBA - Snapshot Replication with Simple steps

Published: 03 October 2013
on channel: Naresh Vadrevu
15,766
22

SQL Server Agents participated in Snapshot replication :-

SQL Server Agent:
SQL Server Agent hosts and schedules the agents used in replication and provides an easy way to run replication agents. SQL Server Agent also controls and monitors operations outside of replication

Snapshot Agent
The Snapshot Agent is typically used with all types of replication. It prepares schema and initial data files of published tables and other objects, stores the snapshot files, and records information about synchronization in the distribution database. The Snapshot Agent runs at the Distributor

Distribution Agent
The Distribution Agent is used with snapshot replication and transactional replication. It applies the initial snapshot to the Subscriber and moves transactions held in the distribution database to Subscribers. The Distribution Agent runs at either the Distributor for push subscriptions or at the Subscriber for pull subscriptions


Watch video SQL Server DBA - Snapshot Replication with Simple steps online without registration, duration hours minute second in high quality. This video was added by user Naresh Vadrevu 03 October 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,76 once and liked it 2 people.