SQL Serevr Replication – Setup and configure Subscription on SQL 2008R2 – Part 4 of 4
Setup and configure Subscription by www.varindersandhu.in
New Subscription wizard as below
Setup and configure Subscription by www.varindersandhu.in
Setup and configure Subscription by www.varindersandhu.in
Select the publication and then press “Next”
Next you have choose the subscriber and subscription database
Setup and configure Subscription by www.varindersandhu.in
Here we are choosing the Push subscription
Select Push subscription (First one) then press “Next”
Setup and configure Subscription by www.varindersandhu.in
Select Agent Schedule “Run Continuously” the press “Next”
Setup and configure Subscription by www.varindersandhu.in
Select Initialize when as “At first Synchronization”
Setup and configure Subscription by www.varindersandhu.in
Select option “Create the subscription”
Setup and configure Subscription by www.varindersandhu.in
Wait for the subscription process to finish.
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/
Pingback: SQL Server - How to Setup SQL Server Replication - Part 0 of 4 - Varinder Sandhu