O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required