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).

cBizHELP

  • On the New Subscriptions Wizard page, click Next.

cBizHELP

  • On the Publication page, click Next.

cBizHELP

  • On the Merge Agent Location page, click Next.

cBizHELP

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

cBizHELP

cBizHELP

cBizHELP

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

cBizHELP

cBizHELP

  • On the Merge Agent Security page, click Next.

cBizHELP

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

cBizHELP

  • Schedule how frequently you want to merge the changes.

cBizHELP

  • On the Synchronization Schedule page, click Next.

cBizHELP

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

cBizHELP

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.

cBizHELP

  • On the Wizard Actions page, click Next.

cBizHELP

  • On the Complete Wizard page, click Finish.

cBizHELP

  • When the Subscription is successfully created, click Close.

cBizHELP


___________________________________________________________________________________________________________

< Back Page 6 of 7 Next >  
___________________________________________________________________________________________________________