Migrate SCCM CB2010 and SQL 2012 to new 2019 servers

Chong 841 Reputation points
2021-01-06T03:10:29.407+00:00

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

Thanks

Chong

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,784 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.
488 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Fiona Yan-MSFT 2,311 Reputation points
    2021-01-06T08:30:17.697+00:00

    @Chong

    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:
    https://home.memftw.com/configmgr-site-backup-restore/
    https://www.sysinfotools.com/blog/migrate-sql-server-database-from-one-server-to-another/
    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 841 Reputation points
    2021-01-06T08:53:59.937+00:00

    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?

    Thanks

    Chong


  3. Chong 841 Reputation points
    2021-01-07T03:21:48.827+00:00

    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?

    Thanks

    Chong


  4. Chong 841 Reputation points
    2021-01-14T03:18:49.387+00:00

    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"
    56350-2.jpg

    And the SCCM site cannot be connected
    56388-3.jpg

    Any idea?

    Thanks

    Chong


  5. Chong 841 Reputation points
    2021-01-14T09:29:37.197+00:00

    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:

    https://social.technet.microsoft.com/Forums/en-US/6c55a1c8-64c7-4720-bc8d-a4ee25856b1e/sccm-console-cannot-connect-to-database?forum=ConfigMgrDeployment
    http://schadda.blogspot.com/2012/08/how-to-fix-issues-related-with_7.html

    But it still have many "ProviderLoadFailure" error and don't have more information to me
    56467-smsadminui.log

    Thanks

    Chong