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 (0×1028)>
*** [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


Comments (5):

  1. shadster says:

    Hi Kent,

    Can you add data mirroring POST upgrade?

  2. Kent Agerlund Kent says:

    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 [...]

Leave a Reply

CAPTCHA Image
(required)