Microsoft® SQL Server 2012 Unleashed

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 40.20 shows the Log Reader Agent (REPL-LogReader category name) for the AdventureWorks2012 database. It is named DATAXDESIGN-PC\SQL2012DXD01-AdventureWorks2012-2.

After initial synchronization has taken place, the Log Reader Agent begins to move transactions ...