How to Recover SCCM CB Primary Server Using SQL Database Backup Configuration Manager ConfigMgr

How to Recover SCCM CB Primary Server Using SQL Database Backup Configuration Manager ConfigMgr with the following video tutorial from HTMD community.

Let’s see “How to Recover SCCM CB Primary Server Using SQL Database Backup”. Sometimes you need to restore the SQL back on the new virtual server or hardware, I have included that also in the below post

So the important point over here is “SCCM CB full backup” is not required for restoring your SCCM CB primary server. Rather, you can restore or recover the primary site server from SQL backup and CD.Latest folder backup (along with package source folders, WSUS folders/DBs etc…).

Patch My PC

Prerequisites:

Following are the prerequisites to Recover SCCM CB Primary Server Using SQL Database Backup Configuration Manager ConfigMgr.

  • Remove existing SCCM servers from domain ensuring you know local admin account details
  • Shutdown existing SCCM servers
  • Rename existing SCCM servers in Vcenter or HyperV to .old
  • Rename new SCCM server in Vcenter/HyperV to existing SCCM server names
  • Delete existing SCCM servers from AD
  • Take new SCCM/ConfigMgr servers off domain and reboot ensuring you have local admin account details
  • Log onto new SCCM/ConfigMgr servers using local admin account
  • Change IPs of new SCCM servers to reflect old SCCM server IP details
  • Change new SCCM servers names to existing SCCM server name and reboot
  • Log on to new SCCM servers as the local admin account
  • Add new SCCM servers to domain and reboot
  • Verify OU, System Management Access, and AD membership information of new SCCM/ConfigMgr servers. Reboot if you have made any changes above
  • Storage migrate any back end storage in VMware/HyperV to ensure that vmdk files and vmx/VHDX files are named correctly

How to Recover SCCM CB Primary Server Using SQL Database Backup Configuration Manager ConfigMgr?

I’ve another 3 posts and videos related to SCCM Current Branch backup and recovery options. You can refer to those posts from here.

The installation of the SCCM CB standalone primary server should be done from CD.Latest folder (p.s – this is because we are doing recovery of the server). I used the native SQL backup option to from SQL management studio to backup the SQL DB.

1E Nomad

And once the recovered server OS is up and running with all the prerequisites(ADK, WSUS, SQL), I restored the SQL DB using management studio from SQL full backup file. All these processes are explained in the below video tutorial.

Recover SCCM CB Primary Server Using SQL Database Backup
Recover SCCM CB Primary Server Using SQL Database Backup

Also, make note of “post recovery” process apart from removal and addition of Intune subscriptions. You need to make sure that all the accounts which are configured in SCCM ConfigMgr CB console should be removed and added back.

If there is any hotfix installed on the SCCM CB server then we need to install the same hotfix after the completion of the recovery Wizard.

Following are the prerequisites which we need to follow during the recovery process SCCM CB primary server:- Hostname Should be same :
Drive Letters should be the same :
Installation Path should be same:
Should have same patch level:
Better to have the same IP: All the prerequisite apps should be installed: SQL Databased is already restored (manually):

Recover SCCM CB Primary Server Using SQL Database Backup

Here is the end to end recovery experience video. (1) How to Recover or restore SCCM CB Primary server using SQL Database Backup – YouTube.

Resources

7 thoughts on “How to Recover SCCM CB Primary Server Using SQL Database Backup Configuration Manager ConfigMgr”

  1. My Site SCCM 2012R2 v 1902 content from 4 servers
    1- SCCMPRI which is Primary server
    2- SCCMDP which is Deployment Server
    3- SCCMDPII which is Distribution Point server
    4- SCCMSQL which SQL DB

    the problem that is my SCCMPRI compromise (you can say its Fail or corrupted) also the last Backup was after the server compromised
    i want recover my SCCMPRI without losing my 3 year work 🙁

    Reply
    • I don’t known whether the prerequisites mentioned above was helpful or not. Here is it for you again
      Following are the prerequisites which we need to follow during the recovery process SCCM CB primary server :-
      Hostname Should be same :
      Drive Letters should be same :
      Installation Path should be same:
      Should have same patch level:
      Better to have the same IP:
      All the prerequisite apps should be installed:
      SQL Databased is already restored (manually):

      Reply
      • Hi, Thanks for the reply, highly appreciated. I have few questions.

        I already have healthy SQL database in a separate server, can i install SCCM primary server in a new server and connect this server to the current SQL database server.

  2. You might need to go through the end to end restore process as I explained …
    1.Take backup and remove the CM_PR1 DB (existing DB ) from SQL
    2. install new SCCM primary with new DB
    3. and then restore the old DB (existing DB which you removed)
    follow all the things explained in the video and other articles which I linked in the above post 🙂

    Reply

Leave a Comment

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