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

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