Export (0) Print
Expand All
0 out of 1 rated this helpful - 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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.