Home Forums SQL Server 2008 SQL Server 2008 High Availability Getting confused in Peer to peer transaction Replication RE: Getting confused in Peer to peer transaction Replication
WorkasDBA
SSCommitted
Points: 1684
More actions
March 29, 2016 at 11:48 am
#1868356
Please refer to the link for 'Considerations for Using Peer-to-Peer Replication'
We recommend that each node use its own distribution database. This eliminates the potential of having a single point of failure.
https://msdn.microsoft.com/en-us/library/ms151196.aspx