Configuration manager sql query

Question

I am in a situation where our configuration manager app server died. I sql server is intact. Is there a sql query that would extract all of the various site settings that would allow me to rebuild?

Thanks

Rene

Answer 1

Hi, @Anonymous

Just checking to see if there's any update. Have you tried method provided by Garth? We would like to know the current status of the problem.

If you want to re-build the site on the original server, it's better for you to clean the exiting server before recovering the CM site using the exsiting database, so that there isn't any previous configuration can cause conflicts during the site recovery process. The following steps can be used for your reference:

1. Delete any registry entries starting with SMS from HKLM\System\CurrentControlSet\Services
2. Uninstall the Configuration Manager console
3. Restart the server and confirm that all the registry keys with SMS are deleted

Then you can start to install the Configuration Manager to recover the site.

For more detail, you can refer to this article: https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/recover-sites

If you need further assistance, feel free to let us know. Looking forward to hearing from you.

---

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.

Answer 2

I have seen a video from Anoop (an old one) but still valid? I have not used this personally though.

https://www.anoopcnair.com/sccm-cb-primary-server-using-sql-database-backup/