Microsoft® SQL Server 2012 Unleashed

The Distribution Agent

A Distribution Agent moves transactions and snapshot jobs held in the distribution database out to the subscribers. This agent isn’t created until a push subscription is defined for a subscriber. The Distribution Agent takes on the name of the publication database along with the subscriber information ([Machine name][Publication DB name ][Subscriber machine name]). If you look back at Figure 40.20, you see a Distribution Agent (the REPL-Distribution category name) for the AdventureWorks2012 database to a subscriber. It is named DATAXDESIGN-PC\SQL2012DXD01--AdventureWorks2012 - PUBLISH AdventureWork - DATAXDESIGN-PC\SQL2012DXD03-6, where SQL2012DXD01 is the publisher and SQL2012DXD03 is the subscriber.

Those not set up for ...