Hello Folks,

I think you would have a brief idea of what the Replication is all about, and what are the types of Replication and the different agents equipped with the Replication.

Well, this article-post is mainly being focused on how to create a Publisher and Distributor, first time in the system.

Creating a Publisher and Distributor:

It’s being recommended to configure the Distribution, before creating the first publication, because if there happens to be any issue, it will be quite easy to troubleshoot.

NOTE: You at-least need to use SQL Server 2008 for this.

So as to create your first distributor, go through the steps carefully:

1. Connect to the Server. Here it is “Piyush-PC\SQLSERVER2K8R2”. It will be acting as a publisher/distributor or remote distributor using SQL Server Management Studio.

2. Under the Object Explorer, right-click the Replication folder, and select the “Configure Distribution…” option.

1_SQL_Server_Configuring_the_Replication_Part1

3. Click Next on the Configure Distribution Wizard.

4. Distribution Window will flash-up. The Distributor is the server responsible for storing replication information used during synchronizations. So you can select the Server for this:

2_SQL_Server_Configuring_the_Replication_Part1

5. Snapshot Folder will show up. It is a default location where the snapshot agent deposits the snapshot. If this folder does not have an adequate space or if you want to minimize the I/O contention, then it’s better to use the different location.

To allow Distribution and Merge Agents that run at Subscribers to access the Snapshots of their publications, we must use the network path to refer to the snapshot folder.

3_SQL_Server_Configuring_the_Replication_Part1

6. Distribution Databases dialog opens up. The distribution database stores changes to transactional publications until Subscribers can be updated. It also stores historical information for snapshot and merge publications.

4_SQL_Server_Configuring_the_Replication_Part1

7. Now the PUBLISHER. Enable the servers to use this Distributor when they become Publishers. If this is a local publisher/distributor, your publisher will already be selected. If not, then you would have to select the Add button, if you want to enable other publishers to use this distributor.

5_SQL_Server_Configuring_the_Replication_Part1

8. So at the end of the wizard, we can also have Configure Distribution.

6_SQL_Server_Configuring_the_Replication_Part1

9. Click Finish to Complete the Wizard.

10. Click on close.

7_SQL_Server_Configuring_the_Replication_Part1

Your local distributor is now ready to use.

In the next article-post, i will be writing about Creating a Snapshot or Transactional Publication.

And also comments on this!!

 

Regards

Piyush Bajaj

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook