Today I tried to update an SCCM 2012 environment to 2012 SP1 according to the manuals from Microsoft and the checklist from Jason Sandys. Then we got a lot of questions about the TESTDBUPGRADE Step, because we had no test environment and have to run it in the production on a copy of our DB:

  1. Where do we have to run this Command? On the Site Server or on the SQL Server?
    It’s possible to run it on both. You can specify the connection parameters like that: setup.exe /TESTDBUPGRADE SERVERNAME\INSTANCENAME\DBNAME
  2. Does this command change something on the system?
    Yes it does. We discovered, that it creates certificates on the SQL server, restarts SQL services and installs a bootstrap service on the database server!

So you should definitely run this command on a test database server with the same version of SQL installed as in the production. With the described command line arguments you can run it also on a remote system like in the screenshot below.



Follow me

Thomas Kurth

Principal Workplace Consultant at baseVISION AG
I’m a consultant, trainer and architect for workplace management and enterprise mobility projects with Microsoft Technologies in the past eight years. I love to push and design the modern workplace based on Windows 10, EM&S and O365 for my customers which is the only answer for the current security threats, agile world and the fast-changing business requirements of my customers. Important for me is to simplify and automate the operational processes, because there are the highest costs.

Thomas Kurth
Follow me

Latest posts by Thomas Kurth (see all)