SCCM Sql Server Migration from 2021 to 2019

Question

Hi We currently have SCCM 2012 r2 with SQL 2012.

We plan on upgrading the environment to new servers as we need to decommission the old physical servers.  I have setup a new VM 2019 with SQL 2019, whats the best ways to upgrade from SCCM SQL 2012 and migrate to SQL 2019 ?

Should I firstly upgrade the SQL 2012 server and then backup and restore on the new server?

Sql 2012 is currently on the same box as SCCM and we plan to move SQL to a separate box.

Answer ( 1 )

  1. You can follow SCCM Migration SQL Server step-by-step guide by Rajul and let us update if any further queries.

    +SCCM Migration SQL Server – Installation|Part 1| ConfigMgr

    https://www.anoopcnair.com/sccm-migration-sql-server-sql-2017/

    + SCCM SQL Server Database Migration | Part 2 |ConfigMgr| Step by Step

    https://www.anoopcnair.com/sccm-sql-server-database-migration-part-2/

Leave an answer

Sorry, you do not have permission to answer to this question .