Correct – SCCM 2012 does not support SQL Mirroring and can breake a SCCM SP1 upgrade

As stated here SQL mirroring is not supported for the ConfigMgr database. However a technet article do not stop all database administrors’s from enabling the setting anyway believing that it will not cause any issues – but boy it does. SQL mirroring will break the SCCM SP1 upgrade process and leave the primary site server in a non-functional mode where a site restore is the only way back.

The issue can be found in the ConfigMgrSetup.log file.

USE [cm_ps1]; ALTER DATABASE [cm_ps1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;  $$<Configuration Manager Setup><01-11-2013 10:38:29.887+00><thread=4136 (0x1028)>
*** [42000][1468][Microsoft][SQL Server Native Client 11.0][SQL Server]The operation cannot be performed on database "cm_ps1" because it is involved in a database mirroring session.

image 

Unfortunately the upgrade prerequisite checker do not check for mirroring

By | 2013-01-13T10:29:19+00:00 January 13th, 2013|Configuration Manager (SCCM), General info|5 Comments

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

5 Comments

  1. shadster January 14, 2013 at 16:57 - Reply

    Hi Kent,

    Can you add data mirroring POST upgrade?

  2. Kent January 14, 2013 at 17:42 - Reply

    I wouldn’t do it, it’s still not supported and WHO knows when it will break Again. Today we saw the first post SP1 hotfix and there is no telling if that will Alter the database and break it.

  3. […] a SCCM SP1 upgrade January 14, 2013 robertrieglerwien Leave a comment Go to comments http://blog.coretech.dk/kea/correct-sccm-2012-does-not-support-sql-mirroring-and-can-breake-a-sccm-s… Share this:PrintEmailLike this:LikeBe the first to like this. Categories: MS: Deployment […]

  4. […] Correct – SCCM 2012 does not support SQL Mirroring and can breake a SCCM SP1 upgrade […]

Leave A Comment