Recap
Snapshot replication is used for copying whole objects from a publisher to a subscriber. Although a snapshot can be filtered, snapshot replication has no facility for sending incremental changes to subscribers.
SQL Server implements snapshot replication via the Snapshot and Distribution Agents. The Snapshot Agent handles creating the snapshot, which consists of BCP data files and T-SQL scripts. The Distribution Agent takes the snapshot and applies it to subscribers. All along the way, both agents access and update replication system tables in the distribution database.
Get Guru's Guide to SQL Server Architecture and Internals, The 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.
