How to recover a ConfigMgr 2012 site using a restored db

 

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

clip_image001

Click Next >

 

clip_image002

Note: if run on a ConfigMgr site server, only two options are available: Recover a site, or Uninstall the CM site. Choose Recover & Next >

clip_image003

Choose option, use a site database that has been manually restored

Click Next >

clip_image004

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 >

clip_image005

Click Next >

clip_image006

Click Next >

clip_image007

Select the agreement options & Click Next >

clip_image008

Enter path for previously downloaded prereqs (you did download them, right?)

Click Next >

clip_image009

Click Next >

clip_image010

Click Next >

clip_image011

No change needed, but new with R2, Click Next >

clip_image012

Click Next >

clip_image013

Click Next >

clip_image014

Click Begin Install >

clip_image015

View log will show details…

clip_image016

clip_image017

clip_image018

Advertisements
This entry was posted in ConfigMgr, SQL Server, TechEd 2014. Bookmark the permalink.

7 Responses to How to recover a ConfigMgr 2012 site using a restored db

  1. Nick says:

    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

  2. Nick says:

    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?

  3. Pingback: Top 5 blog posts for 2016 | Steve Thompson [MVP]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s