Migrate SCCM CB2010 and SQL 2012 to new 2019 servers

Chong 846 Reputation points

Hi all,

We have two Win2012 servers which installed SCCM CB2010 and SQL 2012 Server. Now we planning to migrate them to Win2019 server and SQL 2019 Server
Seems we can use backup and recovery to migrate the SCCM to new server.

For the SQL server, do we need to migrate the existing SQL server first? Or just backup the database and restore to new SQL 2019 Server? How about the reporting services



SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,827 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Fiona Yan-MSFT 2,311 Reputation points


    Thank you for posting in Microsoft Q&A forum.

    There are many methods to perform the action, it's recommended that using in-place SQL upgrades and Site backup and restore.

    The mainly steps should be like this:

    • In-place upgrade to SQL 2019 on the old server.
    • Migrate SQL to new server (2019).
    • Backup/restore SCCM primary site to the new OS server (same name for the server).
    • Move the database and SCCM roles.
    • SQL and SCCM same box (Server 2019 and SQL 2019).

    The following articles including the site backup and restore:
    backup-and-recovery the site
    recover the sites

    Also, we could refer to these two excellent blogs:
    Note: This is non-official Microsoft article just for your reference.

    Have a nice day!

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Chong 846 Reputation points

    Hi @Fiona Yan-MSFT ,

    Thanks for the information.

    For the "Backup/restore SCCM primary site to the new OS server (same name for the server)", it should use the same server name?
    So we need to cleanup the existing SCCM server and disjoint it from the domain, then setup a new SCCM server?

    This should required very long downtime. Any method can have shorter download time for the server migration?



  3. Chong 846 Reputation points

    Sorry that I am new on SCCM so may have many thing unclear

    As we have existing SQL 2019 server for other services already, if we want to recovery the SCCM to this SQL, the step will be:

    1. In-place upgrade to SQL 2019 on the old SCCM SQL 2012 server.
    2. Migrate the SCCM DB to new SQL 2019 server.
    3. Backup/restore SCCM primary site to the new OS server (same name for the server).
    4. Move the database and SCCM roles. <<< Can explain more about this? The SQL and SCCM still to configure after restore to new server?



  4. Chong 846 Reputation points

    Hi @Fiona Yan-MSFT

    I tried to restore the SCCM to the new server (Just restore the site server, SQL not restore as we will use the existing SQL first). The setup is completed but some components still "installing"

    And the SCCM site cannot be connected

    Any idea?



  5. Chong 846 Reputation points

    Hi @Fiona Yan-MSFT

    I see the elapsed time stopped and wait around 1 hours but those components still show "installing" so I click next to completed the wizard.

    From the SmsAdminUI.log, it have some RPC server error. I tried to fixed the problem as below:


    But it still have many "ProviderLoadFailure" error and don't have more information to me