Overview

SQL Server 2005 Replication Creating Subscriptions

The Subscriptions
To invoke the new subscription wizard right-click the publication (or the local subscriptions folder) and choose New Subscriptions from the pop-up menu. After you get past the introductory screen, select the publication for which you want to create Subscription(s).

• On the New Subscriptions Wizard page, click Next.

• On the Publication page, click Next.

• On the Merge Agent Location page, click Next.

• On the Subscriber Wizard page, browse the Subscription Database and click Next.

• On the Snapshot Agent Security page, select Run under the SQL Server Agent account and Select the SQL Server login and click Next.

• On the Merge Agent Security page, click Next.

• In the synchronize schedule wizard, select the Agent schedule as Define schedule and click Next.

• Schedule how frequently you want to merge the changes.

• On the Synchronization Schedule page, click Next.

• The Initialize Subscriptions page, uncheck Initialized and click Next.

Note: If you restore the publisher backup in Subscriber after snapshot ran, do not specify the initialize. For fresh database you have to check the initialize.

• On the Subscription Type page, click Next.

• On the Wizard Actions page, click Next.

• On the Complete Wizard page, click Finish.

• When the Subscription is successfully created, click Close.