Pb to restet Configuration Manager install ?

Aziz Rachid 1 Reputation point
2023-06-14T14:30:19.6233333+00:00

I have SCCM version 2207. I have pb with console. I want to reset de configuration but didn't work. I receive this message :

"this site's database must be restored on the select SQL server before reset can continue"

When I trie to upgarde the version. this option was diasable.

thanks

Microsoft Security | Intune | Configuration Manager | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Simon Ren-MSFT 40,386 Reputation points Microsoft External Staff
    2023-06-15T02:44:11.3166667+00:00

    Hi,

    Thank you for posting in Microsoft Q&A forum.

    It seems that you are trying to reset the configuration of your SCCM version 2207, but you are facing an error that says "this site's database must be restored on the select SQL server before reset can continue". This error can occur when the Configuration Manager site database is not available or is not accessible.

    To resolve this issue, you need to restore the Configuration Manager site database. (For your data security, it is recommended to take a backup of your site database before you attempt to reset the site.)

    To restore the Configuration Manager site database, you can follow the below steps:

    1. Connect to the SQL Server that hosts the Configuration Manager site database.
    2. Restore the Configuration Manager site database from the backup.
    3. After the database is restored, run the SCCM setup and select the option to Reset site with no configuration changes.
    4. Select the restored Configuration Manager site database on the SQL Server and complete the reset process.

    For your reference:

    MANUALLY RESTORING A CONFIGMGR DB

    Run a site reset

    Thanks for your time. Have a nice day!

    Best regards,

    Simon


    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.

    0 comments No comments

  2. Simon Ren-MSFT 40,386 Reputation points Microsoft External Staff
    2023-06-23T08:51:13.97+00:00

    Hi,

    Hope everything goes well. Do you need any further assistance about this issue? If yes, please feel free to let us know, we will do our best to help you.

    If the response is helpful, it's appreciated that you could click "Accept Answer" and upvote it, this will help other users to search for useful information more quickly.

    Thanks for your time.

    Best regards,

    Simon

    0 comments No 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.