Peer to Peer replication conflicts

• learningsqlserver

  SSC Veteran

  Points: 238

  More actions

  November 29, 2010 at 7:51 am

  #231749

  Hi,

  I have to implement a P2P however not sure how to resolve conflicts if they occur.

  As per BOL ,partitioning insert ,update and delete helps in resolving conflicts in P2P replication.

  If simultaneous update/insert/delete is performed on same row at diffrent nodes conflict is going to occur.

  Am i missing something.

  Please advice.

  Thanks

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  November 30, 2010 at 12:59 am

  #1256632

  Look at this

  http://technet.microsoft.com/en-us/library/bb934199.aspx

  or search on the internet using Peer to Peer replication conflicts sql server