1.

What are the agents in replication?

Answer»

  • SNAPSHOT Agent: Copy Schema+Data to snapshot folder on distributor. Used in all types of replication.
  • Log reader Agent: Sends transactions from Publisher to Distributor. Used in transactional replication
  • Distribution Agent: Applies Snapshots / Transactions to all subscribers’ runs at a distributor in PUSH and Runs at Subscriber in PULL. Used in transactional and transactional with updatable subscriptions.
  • Queue reader Agent: Runs at distributor send back transactions from subscriber to publisher. Used in Transactional With updatable subscriptions.
  • Merge Agent: Applies INITIAL snapshot to subscribers, from the next time SYNCHRONIZE by resolving the conflicts.


Discussion

No Comment Found