SCCM 2012 R2 TESTDBUPGRADE

SCCM 2012 R2 TESTDBUPGRADE

Before upgrading SCCM 2012 to for example 2012 R2 we should test the upgrade on a copy of the database.

http://technet.microsoft.com/en-us/library/8b6ff5c8-3c84-49fb-8bc7-930bed865de5#BKMK_TestSiteDBUpgrade

The documentation states: Make a copy of the site database, and then restore that copy to an instance of SQL Server that uses the same edition as your site database and that does not host a Configuration Manager site. For example, if the site database runs on an instance of the Enterprise edition of SQL Server, make sure you restore the database to an instance of SQL Server that also runs the Enterprise edition of SQL Server.

If the SQL server is running on a virtual machine then it might for some be nice to just test it on a clone of the production server without network connectivity.

If you try it you will see this error: SQL instance hosting an active site Database – Cannot run TESTDBUPGRADE on a SQL Instance which host an active site Database. And Begin TestDBUpgrade is unavailable (grayed out).

image

If you delete the key HKEY_LOCAL_MACHINESOFTWAREMicrosoftSMS

image

After deleting the registry key you will be allowed to run TestDBUpgrade.

image

image

Table of Contents

Share this post
Search blog posts
Search
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.
Modern Workplace consultant and a Microsoft MVP in Windows and Devices for IT.

Infrastructure architect with focus on Modern Workplace and Microsoft 365 security.

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Cloud & Security Specialist, with a passion for all things Cybersecurity

Cloud and infrastructure security specialist with background in networking.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

follow us in feedly
Categories

Follow on SoMe