Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Initialize a Subscription Manually (SQL Server Management Studio)

Initialize a subscription to a publication manually by copying the schema (and typically data) to the subscription database. The schema and data should match the publication database. Then specify that the subscription does not require schema and data on the Initialize Subscriptions page of the New Subscription Wizard. For more information about accessing this wizard, see How to: Create a Push Subscription (SQL Server Management Studio) and How to: Create a Pull Subscription (SQL Server Management Studio).

When you synchronize the subscription for the first time, the objects and metadata required by replication are copied to the subscription database.

To initialize a subscription to a publication manually

  1. Ensure that the schema and data are copied to the subscription database.

  2. Clear the Initialize check box on the Initialize Subscriptions page of the New Subscription Wizard. Do this for each subscription that requires only replication objects and metadata to be copied.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.