January 26, 2012 at 11:36 pm
Do we require to exec sp_addarticle SP on publisher and subscriber both when we need to add any article ? whenever i am adding it on one node (pub) the agents shows failure
Error :
Peer-To-Peer topologies require identical articles in publications at all nodes prior to synchronizing. Articles in publication [INBKUMAR02\SQL2008R2].[ESS].[ESS] do not match articles in [INKMEHTANI02\SQL2008R2].[ESS].[ESS]. (Source: MSSQLServer, Error number: 20803)
Get help: http://help/20803
it got disappear if i apply same sp_addarticle to other node (sub) too.i got confused do we need to apply on both sides to have article ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 27, 2012 at 11:33 am
Bhuvnesh (1/26/2012)
Do we require to exec sp_addarticle SP on publisher and subscriber both when we need to add any article ?
You've almost answered your own question. In peer to peer replication all servers are publishers AND subscribers. You need to run it on all publishers. i.e. all of them.
They are all equals.
http://www.thefreedictionary.com/peer
peer 2 (pîr)
n.
1. A person who has equal standing with another or others, as in rank, class, or age: children who are easily influenced by their peers.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply