Tag: P2P

Peer 2 Peer Replication fails with Incorrect syntax near ‘sp_MS…’ (Source: MSSQLServer, Error number: 102)

Symptom Creating a Peer 2 Peer publication from SQL scripts and you observe the Distribution Agents failing with “incorrect syntax near”. These messages can be observed in SQL Server Agent job history, in SQL Profiler Trace, or in Agent -Output logging. Errors show below were raised on (insert) stored procedure for Production.Product table for AdventureWorks2017
Read More »

New Disaster Recovery option for Peer-2-Peer (P2P) Replication in SQL 2008

Problem: Following a severe systems/replication failure, SQL 2005 requires database updates to be frozen until the peer is re-established. Peer-to-Peer Transactional Replication http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx Maintenance Considerations The following actions require the system to be quiesced (stopping activity on published tables at all nodes and ensuring that each node has received all changes from all other nodes):
Read More »

Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008.  You can view this video from the BLOG or double-click to open in YouTube.  He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes
Read More »