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
After initial synchronization has taken place, the Log Reader Agent begins to move transactions ...