Sunday, February 26, 2012

Adding a New Subscriber To Existing Snapshot Replication

After you have created a publication, you can configure one or more servers as subscribers.

Open SQL Server Management Studio, and connect to the instance by selecting from server drop down list.

Expand Replication, right-click Local Subscriptions, and click New Subscription. 

This brings you to the New Subscription Wizard welcome screen. Click Next to continue.

On the Publication screen, select the default instance of your server from the Publisher drop-down list.

Now you have to select "Adventure_Publisher" from the Databases and Publications list, and click Next to continue.

On the Distribution Agent Location screen, you are asked which machine should run the replication agents at the distributor end or at the subscriber end. Because you want to create a pull subscription, select the Run Each Agent at Its Subscriber option, and click Next.

On the Subscribers screen, you can choose a subscriber for the publication. Check the box next to the Subscriber instance of your server.

Then the drop-down list is populated with all the available databases on the subscriber. Select New Database from the list to open the New Database dialog box. 

Enter "New Database" in the Database Name box, click OK, and then click Next.

Now you need to set the distribution agent security. To do so, click the ellipsis (…) button in the Subscription Properties list.

Usually you have to create an account for the agent to run under, but to make the task simpler, you will run the agent using the SQL Server Agent account, so select the radio button for that option, and click OK. and back at the Distribution Agent Security screen, click Next to continue.

Now step is to set the synchronization schedule, so select Define Schedule.

In the New Job Schedule dialog box, under Frequency, set Occurs to Weekly On Sunday, and click OK. And back at the Synchronization Schedule screen, click Next.

Now you have to specify SQL Server when to initialize the subscription, if at all. If you have already created the schema (an empty copy of the database to be replicated) on the subscriber, then you do not need to initialize the subscription. In this case, you should select Immediately from the drop-down list, make sure the Initialize box is checked, and click Next to continue.

On the Wizard Actions screen, select both the wizard create the subscription, write a script to create the subscription and click Next to continue.

Now select the location where you want to save the Create Subscription Script in your server and click  Next to Continue.

On the Complete the Wizard screen, review your options, and click Finish to create the subscription.

When the wizard is finished, click Close.

Click here for Configuring Snapshot Publication In SQL Server 2008 through Step By Step.
How Snapshot Replication Works. Setting Up Snapshot Replication A Step-by-step Guide. Snapshot Replication in Microsoft SQL Server. ransactional replication. snapshot replication sql server 2008. snapshot replication sql set up snapshot replication sql server 2008. sql snapshot replication 2005. snapshot replication sql server 2005. snapshot replication in sql server 2005 step by step. snapshot replication in sql server 2008 step by step. snapshot replication in sql server 20012 step by step guide. step by step tutorial. step by step guide to configure snapshot replication. Step by Step snapshot Installation. Step-by-step procedure. snapshot replication step by step. Step by Step Guide to. sql server step by step. sql server step by step replication ebook. microsoft sql server step by step replication ebook. sql server replication step by step tutorial. step by step installation of sql replication. microsoft sql server 2008 replication step by step. What is Snapshot Replication. how to add subscription to the snapshot publication, replication interview Q&A, FAQ.


Post a Comment