How to Recover Restore SCCM Primary Site Server Database Part 1 ConfigMgr Endpoint Manager

How to Recover Restore SCCM Primary Site Server Database Part 1 ConfigMgr Endpoint Manager. System Center Configuration Manager SCCM Recovery options are changed.

How to Recover Restore SCCM Primary Site Server Database Part 1 ConfigMgr Endpoint Manager
How to Recover Restore SCCM Primary Site Server Database Part 1, ConfigMgr Endpoint Manager

Remember, we have to run the Site Repair Wizard (after completing the installation wizard) in ConfigMgr 2007, but this is changed for good in ConfigMgr 2012. More details about ConfigMgr 2007 Site Repair Wizard – Site Repair Wizard Step by Step Guide.

Related post – What’s New In SCCM Windows 10 Servicing Dashboard | ConfigMgr HTMD Blog (anoopcnair.com)

Patch My PC

How to Recover Restore SCCM Primary Site Server Database Part 1 ConfigMgr Endpoint Manager

Now, In ConfigMgr 2012, the Recovery a Site option is part of Installation Wizard.

image

“Site Server recovery” and “Site Database recovery” are the TWO key parts of the recovery process in CM2012. More details about recovery – through TechNet documentation.

Site Database recovery behavior varies with SQL Server Change Tracking Retention Period and Site Database recovery scenarios. More details about SQL Server Change Tracking Retention Period and Site Database Recovery Scenarios.

1E Nomad

In this post, we are going to recover a primary site with GOOD backup (More details about – Backup Site Server maintenance task). Note: We can make sure that from Smsbkup.log. Look for message ID “5035” which indicates that the site backup was completed without any errors. I’m able to successfully recover the primary site which is having a secondary server with the following process.

If you DON’T have a GOOD backup of the primary site and your primary server is NOT a stand-alone one then refer to the following post to do the recovery- Part 2.

I’ve already completed the rebuild of the server with the same name, path, Drive letters, and Patch level. Also, installed and configured IIS, DotNet 4, SQL, and WSUS prior to the start of the recovery process.

1. Start: the ConfigMgr/SCCM 2012 Setup from the System Center 2012 Configuration Manager installation media, we’ve to run this setup from the server which you want to recover.

image

2. Select the option called “Recover a Site” to recover the primary site which you lost.

Note from TechNet: When Setup detects an existing Configuration Manager site on the server, you can start a site recovery, but the recovery options for the site server are limited. For example, if you run Setup on an existing site server when you choose recovery, you can recover the site database server, but the option to recover the site server is disabled.

image

3. Site Server and Database Recovery: options are available in the following wizard.

As mentioned above there are TWO parts in the recovery scenario, Site Server recovery, and Site Database recovery.

Site Server: Select “Recover this Site Server using an existing backup ” and browse to the backup file location.

Site DataBase: Select “Recover the Site Database using the backup set at the following location” and browse to the backup file location.

image

SCCM Site Recovery Information

4. Site Recovery Information: This page in the wizard has already detected our Primary site and CAS details from the backup files. Note that CAS server details are already filled in the wizard.

Note: When recovering a primary site, you have got the option to specify the CAS to which the primary was previously connected. Leave this setting blank when the primary site was not previously connected to a central administration site. The option is DISABLED when Setup has detected that you are recovering a CAS.

Recover Restore SCCM Primary Site Server Database
Recover Restore SCCM Primary Site Server Database

Prerequisites Down during SCCM Server Restore

5. Prerequisites Download: Over here, we need to provide the prerequisites file details so that the SETUP can verify the files and proceed with the recovery.

Note: We’ve skipped two pages called “Product Key”, Microsoft Software License Terms” and “Prerequisite Licenses”.

Recover Restore SCCM Primary Site Server Database
Recover Restore SCCM Primary Site Server Database

Site and Installation Settings – Recover Restore SCCM Primary Site Server Database

6. Site and Installation Settings: Note that the site code, Site name details are already filled & greyed out (this information is already taken from the backup files). We can select the installation folder, remember it’s always better to install the ConfigMgr in the same location.

Recover Restore SCCM Primary Site Server Database
Recover Restore SCCM Primary Site Server Database

7. DataBase Information: Most of the details are already filled in and greyed out on this page. Server Name, Database Name. The only option that we can change is SSB Port 4022.

image

8. Prerequisites Check: This will run the check and we can ignore the two warnings shown in the below pic (as this is a LAB environment, it’s always better to SET maximum memory allocation to SQL server). Click on “Begin Install” to start the recovery.

Note – We have skipped two pages “Customer Experience Improvement Program Configuration” and “Setting Summary”. Those are just default settings.

image

9. Install: This page shows us the progress of the installation and recovery process.

In the following pic, the process which is going on is “Data Recovery in Progress”.

image

10. Verify ConfigMgrSetup.log: We can find detailed information about the actions performed by the recovery in ConfigMgrSetup.log and also details about the resync (BCP) happening from CAS Database (the changes that happened in the hierarchy after the last good backup).

RCM received a message from “CAS Server”, BCP initialization started

RCM received a message from “CAS Server”, BCP is in Progress

image

RCMCtrl.log – Recover Restore SCCM Primary Site Server Database

11. Verify RCMctrl.log to check whether the resync has been completed at the recovered primary site “PRI”. More details about Site to Site Database Replication.

RECOVERY DONE: All the replicated data has been recovered at site PRI

image

12. Post Recovery Tasks: To complete the recovery of this site, you must manually complete the following actions which are NOT performed by setup.

a) In the ConfigMgr console, re-enter the passwords for the following accounts. In our scenario, we need to re-enter the password of the account mentioned in the following pic.

b) Reinstall the following hotfixes – If there is any hotfix need to be installed or not. In our case, there is no hotfix requirement.

c) More details about post-recovery activities have been saved to a file called for later reference C:\ConfigMgrPostRecoveryActions.HTML.

More details about Post Recovery process (IIS configuration, Recover Content Files): http://technet.microsoft.com/library/gg712697.aspx#BKMK_PostRecovery

image

Recover Restore SCCM Primary Site Server Database

NOTE from the comments below.

You should add in your article: consider you have a VM with a Primary SCCM Site and a regular SCCM daily backup is done to volume E. One day, your VM failed and you could only save volume E data (where the good SCCM backup is stored).

So, you rebuild the VM from scratch, mount volume E, install Windows roles and features, install SQL, Windows ADK, etc. Then, you decided to recover the SCCM site and database. Inserting the original SCCM installation media does not work, since Recover a site is grayed out.

What you have to do is go to the SCCM backup folder, then to CD.Latest folder and run setup from there. Once you do that, the option Recover a site is available. Please add this useful information for people facing this scenario.

Author

Anoop is Microsoft MVP! He is a Solution Architect on enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, Intune. He writes about technologies like ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.…

10 thoughts on “How to Recover Restore SCCM Primary Site Server Database Part 1 ConfigMgr Endpoint Manager”

  1. Hi Anoop,

    I have a standalone Primary site model with SQL Cluster database. I want to migrate it from 1 DC to another DC. Can you please suggest me how can i migrate it.

    Reply
    • Hi ! If it’s plain DC to DC 1 change without changing domains then we don’t have much to do. However, if we’re planning to move from domain 1 to domain 2 then it’s NOT supported. Can you confirm which is your scenario?

      Regards
      Anoop

      Reply
  2. Hi Anoop,

    In my current environment there are two SCCm servers – SCCM 2007 & SCCM 2012 R2. Now i have installed separate server SCCM2012 R2. Please suggest me how can i copy database backup of both the servers in new server. or what’s the easiest way to consolidate all SCCM in one.

    Reply
  3. Hi Anoop ,

    I have Scenario here , We have one Stand alone Primary SCCM 2012 site XXX and SQL server is installed on diff server yyy .
    Now , We are planning to move SCCM and SQL server to diff data center and request to let me which recovery option is better to perform as we are coping all data from the servers and Sql database will be restore as it is.

    Reply
  4. Hi Anoop,

    In my environment, I have primary site server, distribution point server and SQL server (Client was also installed in all 3 server). I have a good back up of primary site server. I deployed two applications and it was installed in all the three server. After this my primary site server crashed and other two servers are still fully functional.

    Is there the way to recover that state of Primary site server where my two application was installed? or I have to deploy those two application again after doing my recovery?

    Any suggestion or help will be beneficial.

    Thank you

    Reply
  5. Interesting article – I was enlightened by the facts – Does anyone know if I might be able to get access to a template DD 250 document to complete ?

    Reply
  6. Hello, and thanks for the post. There is an scenario you should add in your article: consider you have a VM with a Primary SCCM Site and a regular SCCM daily backup is done to volume E. One day, your VM failed and you could only save volume E data (where the good SCCM backup is stored). So, you rebuild the VM from scratch, mounted volume E, install Windows roles and features, install SQL, Windows ADK, etc. Then, you decided to recover SCCM site and database. Inserting the original SCCM installation media does not work, since Recover a site is grayed out. What you have to do is go to the SCCM backup folder, then to CD.Latest folder and run setup from there. Once you do that, the option Recover a site is available. Please add this useful information for people facing this scenario. Regards,

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.