|
Describe the replication agents that SQL Server supports. Snapshot Agent
Log Reader Agent
Distribution Agent
Merge Agent
The Snapshot Agent creates snapshot files and stores on the distribution database. It also keeps track of synchronization status in the distribution database. This is used in all kinds of replication.
The Log Reader Agent moves transactions marked for replication from the transaction log on the Publisher to the distribution database. This is used in transactional replication.
The Distribution Agent moves the snapshot jobs from the distribution database to Subscribers. This is used in Merged and transactional replication.
The Merge Agent is an agent of merge replication that merges incremental data changes that have occurred since the initial snapshot was created
|
