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.

See Also

Concepts

Initializing a Merge Subscription Without a Snapshot
Initializing a Transactional Subscription Without a Snapshot

Other Resources

How to: Initialize a Subscription Manually (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance