SCCM Recovery Restore Site Repair Wizard Step by Step Guide

I’ve been asked to create a site recovery wizard step by step guide with screen shots (for a child primary server restoration). It’s pretty straight forward if you’ve good backups in place (except one or two hiccups explained below). If you don’t have a good backup, it’s going to hit to you very badly and you may need to work extra hours to fix the issue. tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide Here is the experience from Nicolas Moseley – Recovering SCCM Site from a Failed Bad Backup.tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

First of all, I would request you go through TechNet article How to Use the Site Repair Wizard

To level set – Deleted the AD system/machine account of the child primary server. Rebuild the server with same name, Same path, Same Drive letters and Same Patch level. Reapplied all the permissions which are required on System Management container. Also, added the machine account to all the required local groups of the central ConfigMgr server. I’ve already installed my primary site with same name and configured SQL, IIS SCCM / ConfigMgr 2007 (with same site code), R3 and WSUS.

First Issue, I’ve started the Site Repair Wizard with the user account which is used at the time of ConfigMgr and SQL installations. The wizard resulted in an error “SCCM – Repair Wizard has stopped Working”  as shown in the screenshot below. This is a known issue.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Solution :: Run the Site Repair Wizard as administrator as shown in the below screen shot.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Second issue : Central server Database connectivity error faced during the restore and the same is explained at STEP 9 (mentioned below) – Parent Recovery window, even though, I’ve used the same user account which performed SQL and SCCM installation on my central server and it’s also part of local administrator of that box. I tried adding my child primary sever machine account into local administrators group of central server even that didn’t work. Credential window get prompted three times and then the task failed.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Solution :: ENABLE TCP/IP in your SQL server protocols from SQL server Configuration Manager. Also, you can check out windows-noob link for more details (the link is for CM2012 sql configuration but it worked for me in SCCM 07 repair site wizard).

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Recoverymanager.log can be reviewed for details of recovery process (this log file will be created only AFTER step 13)

If you’re looking for a guide which can help you to restore the Central Site then go through I do IT blog post. Make Sure, you’ve taken the backup of “srvacct” folder located at installation location of ConfigMgr 2007, before starting the restore process. This will avoid the issue “OSD and Task Sequences fail after restoring a Configuration Manager 2007 Central site from backup” explained in the KB article 2509330

Process starts from here !!!

1. Enter the Site Server Name to be repaired / restored.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

2. Select the first option and provide the valid Backup folder location.

Note – The second option is used only in the scenario “incase you want to repair or reconfigure an existing site without installing a new site or restoring a site or site database from backup files”

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

3. Specify the date of the site backup which is used to restore the site.

Note – Mention the date of the last good backup that you’ve.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

4. Ensure that three progress steps been completed with green icon.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

5. In this page, we need to specify the parent site code.

In our case, we’re trying to restore the child primary site which reports to the central site with site code CEN.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

6. Create a new sender address for the parent site connection.

Note – If the parent site configuration settings were changed  since the last backup, you can recover from the parent site. Select the “recover data from parent site” option.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

7. Provide the central site details to create standard sender address.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

8. Provide the user name and password to connect to the site server (CEN).

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

9. The Wizard successfully completes the ‘Connect to Server’ and ‘Connect to Provider’ tasks.

However, Credential window get prompted three times and then the repair wizard task failed Parent Recovery, even though, I’ve used the same user account which performed SQL and SCCM installation on my central server and it’s also part of local administrator of that box. I tried adding my child primary sever machine account into local administrators group of central server even that didn’t work.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Solution was to ENABLE TCP/IP in your SQL server protocols from SQL server Configuration Manager. Also, you can check out windows-noob link for more details (the link is for CM2012 SQL configuration but it worked for me in SCCM 07 repair site wizard).

After this I’ve restarted the entire Site Repair Wizard process go to Step 1.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

10. Recover data from parent site – CEN has been completed successfully.

All the following tasks completed with green icons …

Connect to Site Server, Connect to Provider, Connect to Database, Checking for permissions and Recover Site Configuration Data

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

11. Verifying the site hierarchy information in this window.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

12. Verification of package source and Update DPs

It’s not advisable to select update the DPs on this site server option in your production environment as it could create backlog and other issues.  

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

13. Summery Page

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

14. Final Progress

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

15. Here we go !! Successfully completes the site recovery wizard and restoration of the site server.

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

16. ConfigMgr 2007 child primary console after the recovery…

tools sccm console configmgr sccm  SCCM Recovery Restore Site Repair Wizard Step by Step Guide

Posted in: ConfigMgr (SCCM), Console, SCCM, Tools
Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On YoutubeVisit Us On LinkedinCheck Our Feed