SQL Server DBA - Snapshot Replication with Simple steps

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

If I insert something in secondary DB, will it replicate in Primary DB? Anyway its a good tutorial. Thanks

ShahinKabir
Автор

I'm sorry, I'm not watching you type

Syncopator
Автор

you need help with your presentations. good stuff for the first 10 or 12 typing moments.. yikes...

sandman
welcome to shbcf.ru