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 43.20, you see a Distribution Agent (the REPL-Distribution category
name) for the AdventureWorks2014
database to a subscriber. It is named DXD01\SQL2014DXD01--AdventureWorks2014 - PUBLISH AdventureWork - DXD01\SQL2014DXD03-6,
where SQL2014DXD01
is the publisher and SQL2014DXD03
is the subscriber.
Those not set up for immediate synchronization ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.