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?
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:
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.
Reference: Backup and Recovery in Configuration Manager