Perform Test Database Upgrade Before Installing SCCM

0

This post covers the steps to perform test database upgrade before installing SCCM. Most of the time we skip doing test database upgrade and install in-console update directly. I haven’t come across any issue when i did that. However performing test database upgrade is not mandatory. But i recommend you to do it because you never know who would have modified or made some customizations to the existing DB. This post is for my own reference and I will use it when I want to run a test database upgrade.

Perform Test Database Upgrade Before Installing SCCM

Now that you understand why one needs to perform test database upgrade, we look at the steps to do it. I will break down the whole process into steps so that it is much easier to follow.

Step 1 – Prepare your environment for Test Database Upgrade

First of all you need a VM (member server) on which we will perform test database upgrade. Create a VM, install the server operating system and join it to the domain. In the next step install SQL server (follow this guide). The SQL version must run the same edition and version of your production SQL. Once you install SQL server, proceed to step 2.

Step 2 – Backup your Database

In of my previous post, I showed the steps to backup SCCM server. To backup site server, we use the built-in maintenance task “Backup Site Server“. If you have not enabled this task before, you can follow this post. I will cover some steps that will help you backup the SCCM database.

To backup your database, follow the below steps :-

  1. Launch Configuration Manager console.
  2. Navigate to Administration > Site Configuration > Sites.
  3. Click Site Maintenance on top ribbon.
  4. Right click Backup Site Server and click Edit.

Perform Test Database Upgrade Before Installing SCCM

Under Backup Site Server Properties, perform the below steps.

  • Check box Enable this task.
  • Click Set Paths and choose the backup destination.
  • Configure the backup schedule by setting Start after and latest start time schedule.
  • Click OK and close backup site server properties window.

Perform Test Database Upgrade Before Installing SCCM

The backup task runs as per the schedule. If the backup task is already enabled, go to the backup location. Within SiteDBServer folder, we need those two files to copied to new VM.

Perform Test Database Upgrade Before Installing SCCM

Copy both .MDF and .LDF files to the SQL server where we will perform test database upgrade.

Perform Test Database Upgrade Before Installing SCCM

Step 3 – Attach Database Copy

Now that we have got the backup files, login to the SQL server. Right click Databases and click Attach.

Perform Test Database Upgrade Before Installing SCCM

In Attach Databases window, click Add button. In the next step locate the database file. Select the .MDF file.

Perform Test Database Upgrade Before Installing SCCM

The Attach Databases window now shows the MDF file and it’s location. In the bottom pane, it also shows .MDF and .LDF files along with file path. Click OK and close the window.

Perform Test Database Upgrade Before Installing SCCM

Step 4 – Take DB Ownership

In this step we will take the DB ownership. Currently I am logged to this SQL server with an user account named sqladmin. Expand Security > logins and right-click the logged in user account and click Properties.

Perform Test Database Upgrade Before Installing SCCM

Click User Mapping and select the database that you attached. In the bottom pane, select db_owner role membership.

Perform Test Database Upgrade Before Installing SCCM

Step 4 – Perform Test Database Upgrade

We are now good to perform test database upgrade. On your SQL server, mount SCCM ISO.

Perform Test Database Upgrade Before Installing SCCM

Run the command prompt as administrator. In addition, change the path to SMSSETUP\BIN\x64. Type the below command to perform test SCCM database upgrade.

setup.exe /testdbupgrade database_name

Perform Test Database Upgrade Before Installing SCCM

First the prerequisite checks are done. Click Begin TestDBUpgrade button.

Perform Test Database Upgrade Before Installing SCCM

On the info window, click Yes.

Perform Test Database Upgrade Before Installing SCCM

Open the ConfigMgrSetup.log file located on C: drive to monitor the testdbupgrade progress. At the end look for the line “Configuration Manager Setup has successfully upgraded the database“. You can now return to your active site and begin the update installation.

Perform Test Database Upgrade Before Installing SCCM

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More

>