Export (0) Print
Expand All

Snapshot Replication Overview

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

NoteNote

Snapshot replication can be used by itself, but the snapshot process (which creates a copy of all of the objects and data specified by a publication) is also commonly used to provide the initial set of data and database objects for transactional and merge publications. For more information, see Initializing a Subscription with a Snapshot.

Using snapshot replication by itself is most appropriate when one or more of the following is true:

  • Data changes infrequently.

  • It is acceptable to have copies of data that are out of date with respect to the Publisher for a period of time.

  • Replicating small volumes of data.

  • A large volume of changes occurs over a short period of time.

Snapshot replication is most appropriate when data changes are substantial but infrequent. For example, if a sales organization maintains a product price list and the prices are all updated at the same time once or twice each year, replicating the entire snapshot of data after it has changed is recommended. Given certain types of data, more frequent snapshots may also be appropriate. For example, if a relatively small table is updated at the Publisher during the day, but some latency is acceptable, changes can be delivered nightly as a snapshot.

Snapshot replication has a lower continuous overhead on the Publisher than transactional replication, because incremental changes are not tracked. However, if the dataset set being replicated is very large, it will require substantial resources to generate and apply the snapshot. Consider the size of the entire data set and the frequency of changes to the data when evaluating whether to utilize snapshot replication.

For information about implementing snapshot replication, see Designing and Implementing (Replication).

Community Additions

ADD
Show:
© 2014 Microsoft