nerdexam
Microsoft

70-243 · Question #52

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…

The correct answer is B. From Server1, run the Configuration Manager 2012 Setup Wizard. 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…

troubleshooting

Question

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?

Options

  • AFrom Server1, run the Site Repair Wizard.
  • BFrom Server1, run the Configuration Manager 2012 Setup Wizard.
  • CFrom Server2, run Microsoft SQL Server Management Studio, and then attach the backed up SQL
  • DFrom Server2, run Microsoft SQL Server Management Studio, and then restore the backed up SQL

How the community answered

(55 responses)
  • A
    7% (4)
  • B
    76% (42)
  • C
    4% (2)
  • D
    13% (7)

Explanation

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 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.

Topics

#database recovery#site repair#SQL Server restore#disaster recovery

Community Discussion

No community discussion yet for this question.

Full 70-243 Practice