Share via

SCCM database migration

Wasif Kazia Mohamed 1 Reputation point
2021-03-10T05:27:38.107+00:00

We have our SCCM environment (Version 1910) running on Windows server 2016. SCCM database is deployed on Sql Server 2012 running on a Windows Server 2012. We are planning to migrate all the services running on Windows Server 2012 to the newer versions of Server (2016/2019). Plan is to move SCCM database including the reporting services currently on SQL Server 2012 to SQL Server 2017. Found the below link on the migration steps. Need advise if these steps are correct and also on moving the reporting services/database to the new SQL server https://www.anoopcnair.com/sccm-sql-server-database-migration-part-2/

Microsoft Security | Intune | Configuration Manager | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 49,441 Reputation points Microsoft External Staff
    2021-03-11T07:16:36.63+00:00

    Hi, @Wasif Kazia Mohamed
    Thank you for posting in Microsoft Q&A forum.
    Yes, we may refer to the steps you linked to migrate sccm database to another server.
    For reporting services, after the SQL Server database migrated, we need to reinstall the reporting service role on new server and if we have custom reports, we may export from the old server and import to the new server.

    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.

    Was this answer helpful?

    0 comments
  2. Garth Jones 2,076 Reputation points
    2021-03-10T13:28:49.17+00:00

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.