Peer to Peer Replication Configuration

 

PEER TO PEER Replication

We  configuring the Distribution Database on Three servers. We can configure individually also but we  are doing three servers  we should add on the distribution database and also create the three databases on three servers .why  we follow this properties tab, previously we can configured the Distribution Databases  Then  we will follow the Below the Processes. Otherwise we should configure the Distribution databases on three servers separately  .

Windc,Winserver1,Winserver2.Goto replication ..>right click…>distributor Properties..>>go to add Like Below

We can  Add Three Distribution Databases doing in Windc,Winserver1,Winserver2 along with password also

We should create database and table also created and saved the table

Select new Publication in the Local publication of replication

Click on Next

We can Select the Database name what you have mention database name

Click transactional Replication and go to Next

Here select the Articles

Click on Next

Click on Next

Here Select the Security and Click next

Click On OK

 

Click on Next

Click on Next

 

Give Name and Finish

 

 

Once all are success click on close otherwise do the trouble shooting

Once publication is created successfully the go to the properties of the pulication

 

Enabling the option is true it default by false

 

 

 

 

Then go to publisher right click configure the peer to peer topology

We can  select the Publisher name

 

We can  select the winserver1 default database is enabled on that name of windc

We can connect the winserver2 with database name enabled

 

We can Enabled the security On both THREE Servers

 

Click On OK

 

Click on OK

 

We should Select The Distribution agent Security IN SQL Server Agent

 

Click On Ok

 

Click On Next

Click On Next

 

Click On Next

Click On close

 

It will affect The both servers on WinDC

 

We can update any article, the data will update the three servers

We should update win server1

 

 

We can select the updating in win server 2

 

 

 

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.