The Log Reader Agent
The Log Reader Agent is responsible for moving transactions marked for replication from the transaction log of the published database to the distribution database. Each database published using transactional replication has its own Log Reader Agent that runs on the distribution server. It is easy to find because it takes on the name of the publishing database whose transaction log it is reading ([Machine name][Publishing DB name]) and the REPL-LogReader category. Figure 43.20 shows the Log Reader Agent (REPL-LogReader category name) for the AdventureWorks2014 database. It is named DXD01\SQL2014DXD01-AdventureWorks2014-2.
After initial synchronization has taken place, the Log Reader Agent begins to move transactions from the ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
