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.
Incorrect, there is no Site Repair Wizard. The correct answer is A. You have to Run Setup to see the Repair Steps.
0
0
A – wrong. In Setup Wizard there is no option to restore database to another SQL Server. Only to the same server (that in current site configuration). There is no need to configure SPN in some situation, and there is no need to configure SPN to restore database.
B – right. You can use Management Studio to restore database (if you have database backup)
C – wrong. Before attach database you need to restore database.
D – wrong. There is no need to configure SPN to restore database. There is no Site Repair Wizard.
Answer – B.
0
0
A is correct. The Setup Wizard has an option to recover a site which includes the site database.
0
0
Here is a great Weblog You may Find Fascinating that we encourage you to visit.
0
0
the time to study or visit the subject material or internet sites we’ve linked to below the
0
0
very couple of internet sites that happen to become comprehensive beneath, from our point of view are undoubtedly very well really worth checking out
0
0
the time to study or check out the subject material or websites we’ve linked to beneath the
0
0
Wonderful story, reckoned we could combine a handful of unrelated data, nonetheless really worth taking a look, whoa did one particular discover about Mid East has got a lot more problerms as well
0
0
Every once in a whilst we choose blogs that we study. Listed below are the most current web pages that we select
0
0
that could be the end of this article. Here you will come across some web pages that we believe you will appreciate, just click the hyperlinks over
0
0
we came across a cool web page which you may well get pleasure from. Take a appear should you want
0
0