SQL Service Broker and MSDB wrt ConfigMgr DRS

Hi Folks, I came across this weird issue where the messages were stuck in the sys.transmission_queue and we do not see the to_broker_instance column for these messages. It was empty, meaning the message was not yet able to identify the routing service at the receiving end. The rest other sites working meant we had the…

2

ConfigMgr 2012 DRS - Troubleshooting FAQs

Hi Folks, Thanks for your feedback on the previous DRS unleashed post. As promised, this post would take you in the deep analysis and troubleshooting of the ConfigMgr 2012 Data replication services issues. I have tried putting up the format as a Q and A format to answer the questions that came to my mind…

23

ConfigMgr 2012 Data Replication Service (DRS) Unleashed

Hello Folks, Today's post is about the much talked about feature Data Replication Service (DRS) in ConfigMgr 2012.  Data replication Service came as a brand new feature for ConfigMgr 2012 for the replication between the sites along with the legacy file based replication that was used in the earlier versions. Sometimes folks do refer it…

35

ConfigMgr 2012: DRS and SQL service broker certificate issues

Hi Folks, Today's post is about the much talked about feature on ConfigMgr 2012- Data Replication Service (DRS). The replication mechanism internally uses SQL Service broker and I am discussing the three common issues with SSB that can stop the replication.   Issue 1: In the SQL error log we see the following: 'Connection handshake…

16

The ConfigMgr 2012 R2 upgrade from ConfigMgr 2012 SP1 CU3 will fail if you have Pull DPs in your environment.

Hi Folks, Just sharing one of the upgrade issues that we have when we upgrade to R2 from ConfigMgr 2012 CU3 when pull dps are there in the environment.   Note: We have fixed the issue in our latest R2 bits. For more information: http://blogs.technet.com/b/configmgrteam/archive/2013/11/26/replication-errors-in-system-center-2012-r2-configuration-manager.aspx   Issue: ===== CAS and primaries went to the Maintenance…

9

The Distributed Views do not get created in ConfigMgr 2012 SP1 because of the login issue.

Hi Folks, The below post in of the new feature (Distributed views) in the DRS that was introduced in the ConfigMgr 2012 SP1 release. Distributed view in simple terms avoid the flow of the site data across the hierarchy as the views directly can fetch the data from the primary database. The views get created…

1