Redigera

Dela via


Initialize a Subscription

Applies to: SQL Server Azure SQL Managed Instance

Subscribers in a replication topology must be initialized, so that they have a copy of the schema from each article in the publication they have subscribed to and any replication objects that are required, such as stored procedures, triggers, and metadata tables. In addition, the Subscriber typically receives an initial dataset. The default initialization method uses a full snapshot that includes schema, replication objects, and data, but publications can also be initialized without a full snapshot.

For more information, see Initialize a Subscription with a Snapshot and Initialize a Transactional Subscription Without a Snapshot.