PrepAway - Latest Free Exam Questions & Answers

You need to restore the Configuration Manager database to Server3

Your network contains a System Center 2012 Configuration Manage 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 Server3.
You need to restore the Configuration Manager database to Server3.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Register the Service Principal Name (SPN) for the SQL Server service account of Server3. From
Server1, run the Configuration Manager 2012 Setup Wizard.

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

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

D.
Register the Service Principal Name (SPN) for the SQL Server service account of Server3. 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