SQL Serevr Replication – Setup and configure Subscription on SQL 2008R2 – Part 4 of 4

01 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

New Subscription wizard as below

02 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

03 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Select the publication and then press “Next”

Next you have choose the subscriber and subscription database

04 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Here we are choosing the Push subscription

Select Push subscription (First one) then press “Next”

05 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Select Agent Schedule “Run Continuously” the press “Next”

06 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Select Initialize when as “At first Synchronization”

07 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Select option “Create the subscription”

08 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu.in

Wait for the subscription process to finish.

09 Setup and configure Subscription

Setup and configure Subscription by www.varindersandhu

Finally subscriber has been created.

Reference URL
http://varindersandhu.in/2011/08/12/sql-server-how-to-setup-sql-server-replication/