Wednesday, August 24, 2011

Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part-IV

In the last part of this article I have explain how you can configure Subscriber server. Subscriber server is the Secondary or slave server which gets or fetch data from Primary (Publisher) Database.

Amplify’d from eitwebguru.com

In Previous three parts I have explained about

 Today in last part of this series I am going to explain how you can create the Subcriber to the Publisher which will complete the replication setup. Before we start the configuration please make sure that the hostname of both the servers are configured properly and include proper enteries in hosts file (Please refer Part-I for more information).

Creating a Subscription

1) Go to Management studio (On Publisher Server) and right click on the Publication you have created >> New subcriptions…

32 300x281 Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part IV

2) New Subscription Wizard will open. Press Next

33 300x269 Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part IV

 3) Publication: Select the Publication Server from the Drop-down list and then select the Database and publication. Press Next after selection.

34 300x269 Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part IV

 4) Distribution Agent Location:  There are two type of Subscription i.e. Push Subscription and Pull Subscription using which we can setup replication. In Push Subscription publisher server pushes any changes made on database to the subscriber where as in case of Pull Subscription subscriber pull the data from publisher on a specified time. Push method is useful when the changes in database need to be replicated as soon as they occur.

So, select Push Subscription and press Next.

35 300x268 Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part IV

5) Subscribers: Here you have to select the subscriber i.e. Slave-DB, from the drop down “Add Subscriber” select “Add New SQL Subscriber…

36 300x269 Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part IV

You will now get a MSSQL Login prompt which is similar to MSSQL Management Studio. Login to the Subscriber server using the “Hostname” of the server and “SA” Login Details.

Read more at eitwebguru.com
 


0 comments:

About This Blog

The Windows Registry is a database which stores settings and options for Microsoft Windows operating systems. It contains normally information and settings for hardware, operating system software, most non-operating system software, and per-user settings. Registry is used to optimize the security, enhance the functionality, modify the functioning of any software OR settings and many more.

In this blog I have tried to collect all the tweaks and hacks available on various website. I have tested many of these hacks before posting but still I would suggest you to take backup of your registry before trying any of these tweaks and if anything goes wrong while trying these hacks I or this blog will not be held responsible.

  © Blogger templates The Professional Template by Ourblogtemplates.com 2008

Back to TOP