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 »
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 »
I meet with a customer today planning for Peer-2-Peer Replication in conjunction with Microsoft Amalga, our Hospital Information System solution. I thought others would benefit from some of the Q&A that were raised in this meeting. I hope you too find these helpful in your projects. 1. How to monitor replication? >>>Tracer Tokens can be
Read More »
Sateesh Yele | Microsoft SQL Server Support Peer-2-Peer Replication Wizard provides no options to enable table partition switching. There are 2 ways to enable this feature. 1) create the publication on ALL the peers using TSQL sp_addpublication 2) create the subscriptions using the user interface — or — 1) create the publication using the Replication
Read More »
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 »