You need to restore the Configuration Manager database to the new server

Your network contains a System Center 2012 Configuration Manager environment.
The environment contains a primary site server named Server1 and a server named Server2 that
runs Microsoft SQL Server 2008 R2.
Server2 contains the Configuration Manager database.
Server2 fails.
You install SQL Server 2008 R2 on a new server.
You name the server Server2.
You need to restore the Configuration Manager database to the new server.
What should you do?

Your network contains a System Center 2012 Configuration Manager environment.
The environment contains a primary site server named Server1 and a server named Server2 that
runs Microsoft SQL Server 2008 R2.
Server2 contains the Configuration Manager database.
Server2 fails.
You install SQL Server 2008 R2 on a new server.
You name the server Server2.
You need to restore the Configuration Manager database to the new server.
What should you do?

A.
From Server1, run the Configuration Manager 2012 Setup Wizard.

B.
From Server2, run Microsoft SQL Server Management Studio, and then attach the backed up SQL
Server database and log files.

C.
From Server2, run Microsoft SQL Server Management Studio, and then restore the backed up SQL
Server database and log files.

D.
From Server1, run the Site Repair Wizard.

Explanation:
http://technet.microsoft.com/en-us/library/gg712697.aspx
Backup and Recovery in Configuration Manager
Recover a Configuration Manager Site
A Configuration Manager site recovery is required whenever a Configuration Manager site fails or
data loss occurs in the site database. Repairing and resynchronizing data are the core tasks of a site
recovery and are required to prevent interruption of operations. Site recovery is started by running
the Configuration Manager Setup Wizard from installation media or by configuring the unattended
installation script and then using the Setup command /script option. Your recovery options vary
depending on whether you have a backup of the Configuration Manager site database.

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.

Further information:
SCCM 2007 needed you to run Site Repair Wizard.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


DAVE

DAVE

According the explanation answer should be “A”. “Site recovery is started by running
the Configuration Manager Setup Wizard from installation media or by configuring the unattended
installation script and then using the Setup command /script option.”