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.