How to perform a Testdbupgrade before SCCM Installation

Benoit LecoursSCCM3 Comments

Before upgrading to SCCM 1511, it’s recommended to perform a test upgrade on a copy of your production database. We briefly cover the topic on our SCCM 1511 Upgrade post but we wanted to provide a step-by-step procedure. This procedure is not mandatory but gives you a head-ups on installation error you may encounter before your upgrade.

Step 1 | Prepare your environment for SCCM Installation Testdbupgrade

To test the database for an upgrade, you must copy the site database to a SQL instance that does not host SCCM. The SQL version must run the same edition and version of your production SQL.

  • Start by creating a new VM or connect to an existing SQL server that can host your SCCM database.
  • Install the right SQL version. Follow our post on how to install SQL Server if needed.

Step 2 | Backup your database

Once your SQL server is ready to receive the database copy, browse to your latest SCCM Backup.

We will use the SCCM Backup Maintenance task for this post but it’s also supported to use the SQL Database backup.

To see where SCCM backups are stored go to :

  • Open the SCCM Console
  • Go to Administration / Site Configuration / Sites
  • Click on Site Maintenance on the top ribbon
  • Select Backup Site Server, click on Edit

SCCM installation testdbupgrade

  • Take note of the path where your backup are done and browse to that location

SCCM installation testdbupgrade

  • Copy the .MDF and .LDF file to the SQL Server that will be performing the test upgrade

SCCM installation testdbupgrade

If you don’t have a backup, enable the task and schedule it. You can also initiate a manual backup if you want the files now.

  • Go to Monitoring / System Status / Site Status
  • Click on Start / Configuration Manager Service Manager

SCCM installation testdbupgrade

  • Browse to SMS_SITE_BACKUP, right-click it select Query then Start

SCCM installation testdbupgrade

Step 3 | Attach the database copy

We are now ready to perform the test upgrade.

  • Connect to your SQL Server
  • Open SQL Management Studio
  • In the Object Explorer pane, right-click Database and select Attach

SCCM installation testdbupgrade

  • In the Attach Databases screen, click on Add

SCCM installation testdbupgrade

  • Select the MDF file that you copied from the SCCM backup, click Ok

SCCM installation testdbupgrade

  • On the bottom pane, resolve any issues displayed in the Message column. In my example the M: and N: drive are Not Found since they don’t exist on this machine. Click on the  button and point correctly at the Data and Log file
  • Click Ok

SCCM installation testdbupgrade

  • The Message box will remove errors

SCCM installation testdbupgrade

  • The database will be attached

SCCM installation testdbupgrade

We will now check that we have the proper rights on the database

  • Click on Security / Logins
  • Right click your user and select Properties (or create a New Login if your Login is not existing)

SCCM installation testdbupgrade

  • In the User Mapping tab, select the database you just attached and select the db_owner role membership

SCCM installation testdbupgrade

Step 4 | Test the upgrade

We will now launch the SCCM Setup using the switch to test the database migration

  • On the same machine that you attach the database
  • Mount the SCCM ISO
  • Go to \SMSSETUP\BIN\X64
  • Run the following command: (change the database name to refect your name)
Setup /testdbupgrade
setup.exe /testdbupgrade CM_SCD

SCCM installation testdbupgrade

  • The Installation Prerequisite Check windows will open
  • Click on Begin TestDBUpgrade button

SCCM installation testdbupgrade

  • On the warning window, click Yes

SCCM installation testdbupgrade

  • The Installation Prerequisite Check windows will close
  • You need to monitor the progress in the log file located on C:\ConfigMgrSetup.log

SCCM installation testdbupgrade

  • The process took about 20 minutes for a 6.7gb database
  • When completed you’ll have the following line in the log : Configuration Manager Setup has successfully upgraded the database
  • Close the log

SCCM installation testdbupgrade

If you had no error, you can delete the file you imported from your backup and proceed to your real SCCM Upgrade on your production server.

How to perform a Testdbupgrade before SCCM Installation
5 - 1 vote

Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 4 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.

3 Comments on “How to perform a Testdbupgrade before SCCM Installation”

  1. Everything works as mentioned but CAS should have local Admin access on the DB where you are attaching the SCCM DBs for testdbupgrade.

  2. Thank You for the information. In an SCCM Infrastructure having 1 CAS and 2 Primary Sites, does this activity to test the DB be performed on each of the Site Databases (1 CAS and 2 Primary Site DBs)?? If not, what is the recommendation please?

  3. Pingback: Inplace Upgrade of Configuration Manager 2012 R2 SP1 to Current Branch - Step by Step - Anders Rodland's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *