adding article in peer to peer replication

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 26, 2012 at 11:36 pm

  #255562

  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%5B/quote%5D

  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;-)

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  January 27, 2012 at 11:33 am

  #1439549

  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.