Restore Database for SCCM server

Question

Hi Support,

My SCCM site server is healthy, but we need to restore the SCCM database on the existing SQL server. Can I just restore the database from backup?

Or we still need to run the site recovery or maintenance?

Thanks

Answer 1

You can restore the SCCM database but there are some considerations to keep in mind.

1. Database restore from backup:
   1. Yes, you can restore the SCCM database from a backup. This process involves recovering the site database using a backup set.
   2. You can either use the Configuration Manager backup task to restore the site database or create your own backup using a different process (such as a SQL Server maintenance plan).
   3. Ensure that you have a recent and valid backup of the SCCM database before proceeding with the restore.
2. Site recovery or maintenance:
   1. Repair and Resynchronize Data: These are core tasks during site recovery. They ensure that the site functions properly after the restore.
   2. Server Hardware considerations:
      1. If you're using a new server, make sure it meets the general and recovery requirements.
      2. If you're reusing an existing server, clean it by removing any previous configurations related to SCCM.
      3. For site database recovery only, manually delete the site database from the SQL Server and restart the SQL Server.
      4. For full recovery, follow the appropriate steps based on your scenario.
   3. Uninstall Configuration Manager Console: If necessary, uninstall the Configuration Manager console from the server.
   4. Confirm Registry Key Deletion: Ensure that all relevant registry keys related to SCCM are deleted.
   5. Content Library: If applicable, make a copy of the content library.
   6. SQL Server Backup: Back up any other supporting databases, such as WSUS, and note the SQL Server name and instance name.

Make sure to look into our documentation for backup and restore. You can find them at https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/backup-and-recovery and https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/recover-sites

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.