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 19.19 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 DBARCH-LT2\SQL08DE01-AdventureWorks2008-PUBLISH ...

Get Microsoft® SQL Server 2008 R2 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.