This process makes the assumption that the ConfigMgr 2012 Sp1 (or later) SQL Server database was manually restored. There are two ways to restore a CM database; use the SQL Server Enterprise Management Studio restore database wizard or use the SQL RESTORE command.
Now that the database was restored, located your media for ConfigMgr 2012 Sp1 (or later) and launch setup.exe from the *.ISO
[Note: Updated 6/2017 – with ConfigMgr Current Branch 1511 and later – launch site recovery from the cd.latest folder, not the *ISO]
Click Next >
Note: if run on a ConfigMgr site server, only two options are available: Recover a site, or Uninstall the CM site. Choose Recover & Next >
Choose option, use a site database that has been manually restored
Click Next >
Site Database Recovery Options
When you run Setup, you have the following recovery options for the site database:
- Recover the site database using a backup set: Use this option when you have a backup of the Configuration Manager site database that was created as part of the Backup Site Server maintenance task run on the site before the site database failure. When you have a hierarchy, the changes that were made to the site database after the last site database backup are retrieved from the central administration site for a primary site, or from a reference primary site for a central administration site. When you recover the site database for a stand-alone primary site, you lose site changes after the last backup.
When you recover the site database for a site in a hierarchy, the recovery behavior is different for a central administration site and primary site, and when the last backup is inside or outside of the SQL Server change tracking retention period. For more information, see the Site Database Recovery Scenarios section in this topic.
Note
The recovery fails if you select to restore the site database by using a backup set, but the site database already exists.
- Create a new database for this site: Use this option when you do not have a backup of the Configuration Manager site database. When you have a hierarchy, a new site database is created, and the data is recovered by using replicated data from the central administration site for a primary site, or a reference primary site for a central administration site. This option is not available when you are recovering a stand-alone primary site or a central administration site that does not have primary sites.
- Use a site database that has been manually recovered: Use this option when you have already recovered the Configuration Manager site database but have to complete the recovery process. Configuration Manager can recover the site database from the Configuration Manager backup maintenance task or from a site database backup that you perform by using DPM or another process. After you restore the site database by using a method outside Configuration Manager, you must run Setup and select this option to complete the site database recovery. When you have a hierarchy, the changes that were made to the site database after the last site database backup are retrieved from the central administration site for a primary site, or from a reference primary site for a central administration site. When you recover the site database for a stand-alone primary site, you lose site changes after the last backup.
Note
When you use DPM to back up your site database, use the DPM procedures to restore the site database to a specified location before you continue the restore process in Configuration Manager. For more information about DPM, see the Data Protection Manager Documentation Library on TechNet.
- Skip database recovery: Use this option when no data loss has occurred on the Configuration Manager site database server. This option is only valid when the site database is on a different computer than the site server that you are recovering.
Take Default option, Click Next >
Click Next >
Click Next >
Select the agreement options & Click Next >
Enter path for previously downloaded prereqs (you did download them, right?)
Click Next >
Click Next >
Click Next >
No change needed, but new with R2, Click Next >
Click Next >
Click Next >
Click Begin Install >
View log will show details…
Steve Thompson [MVP] 
Hi Steve,
I have restore my SQL database manually, but how can I restore my site server, if I use this option “use a site database that has been manually restored” where and how can I use the site server? I have to set the path for my existing backup of site server.
BR
Nick
Did you see this post on that topic?
https://stevethompsonmvp.wordpress.com/2014/08/01/how-to-recover-a-configmgr-2012-site-using-a-restored-db/
Hi Steve,
Yes I did, but as I informed you I don’t see any Path for site server
If I understand you correctly, if you use the option “use a site database that has been manually restored”, the database has to manually restored first.
There is no other option to choose the path to the backup folder, as you either use the manually restored db, OR the backup path (from maintenance task).
Yes I use that Option “use a site database that has been manually restored” and restore my database with SQL Management Studio. But I have only restored my site database,But I have to restore my site Server too or NOT. how can I restore my site Server?
Ok I understand you now, you mean I use that Option “use a site database that has been manually restored”, the site database has to restore bevor. Then I have to choose that Option “use a site database that has been manually restored”, Am I correct?
Pingback: Top 5 blog posts for 2016 | Steve Thompson [MVP]