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