ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-243 All Questions

View all questions & answers for the 70-243 exam
Go to Exam

Exam 70-243 topic 1 question 33 discussion

Actual exam question from Microsoft's 70-243
Question #: 33
Topic #: 1
[All 70-243 Questions]

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 Managerdatabase.
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 Serverservice 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 backedup 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
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 sitedatabase. Repairing and resynchronizing data arethe 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 onthe 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.
by [deleted] at April 4, 2025, 4:07 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel