O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, 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 Snapshot Agent

The Snapshot Agent is responsible for preparing the schema and initial data files of published tables and stored procedures, storing the snapshot on the distribution server, and recording information about the synchronization status in the distribution database. Each publication has its own Snapshot Agent that runs on the distribution server. It takes on the name of the publication within the publishing database within the machine on which it executes (that is, [Machine][Publishing database][Publication Name]).

Figure 43.20 also shows what this Snapshot Agent looks like under the SQL Server Agent, Job Activity Monitor branch in SQL Server Management Studio (SSMS). The Snapshot Agent (REPL-Snapshot category name) is named

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