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. Here is the experience from Nicolas Moseley – Recovering SCCM Site from a Failed Bad Backup.
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.
Solution :: Run the Site Repair Wizard as administrator as shown in the below screen shot.
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.
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).
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.
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”
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.
4. Ensure that three progress steps been completed with green icon.
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.
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.
7. Provide the central site details to create standard sender address.
8. Provide the user name and password to connect to the site server (CEN).
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.
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.
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
11. Verifying the site hierarchy information in this window.
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.
13. Summery Page
14. Final Progress
15. Here we go !! Successfully completes the site recovery wizard and restoration of the site server.
16. ConfigMgr 2007 child primary console after the recovery…