ConfigMgr / SCCM 2012 –SQL Replication Troubleshooting Guide and Custom Report

Posted in CM2012, SCCM 2007, SCCM 2012, SQL

ConfigMgr 2012 is added one more additional complexity for the admins like me who are not very SQL savvy.

Edit (17-May-2012) – I’ve also gone through some of the excellent Custom SQL replication reports published in the below blog post.

Custom SQL Replication Reports 

To help us in SQL replication related issues, Minfang Lu has published a blog post.

Tips for troubleshooting SC 2012 Configuration Manager Data Replication Service (DRS)

Key points to remember while troubleshooting

1. Use Replication Link Analyzer.
2. Check out the Log files – rcmctrl.log, replmgr.log.
3. Check SQL and Run script spDiagDRS to get more information.
4. Troubleshoot the SQL Service Broker.
5. Reinitiate the site data by sending subscription invalid message.

email

Tags: , , , ,
Written by , Posted .