What should you do?

You are a system administrator for your company. The network has the following servers:A System Center Data Protection Manager (DPM) 2007 server A Microsoft SQL Server 2000 Service Pack 4 server named Server1 Server1 hosts a database named SQLDB. The DPM 2007 server protects SQLDB. You upgrade Server1 to Microsoft SQL Server 2005. You discover that after the upgrade, a table in SQLDB has corrupted. You need to recover SQLDB to its original state. You also need to ensure that the DPM 2007 server continues to protect SQLDB.What should you do?

You are a system administrator for your company. The network has the following servers:A System Center Data Protection Manager (DPM) 2007 server A Microsoft SQL Server 2000 Service Pack 4 server named Server1 Server1 hosts a database named SQLDB. The DPM 2007 server protects SQLDB. You upgrade Server1 to Microsoft SQL Server 2005. You discover that after the upgrade, a table in SQLDB has corrupted. You need to recover SQLDB to its original state. You also need to ensure that the DPM 2007 server continues to protect SQLDB.What should you do?

A.
Remove and re-add Server1 to the DPM protection group. Perform a consistency check for SQLDB.

B.
Stop the DPM 2007 server from protecting SQLDB. Create a new protection group for Server1.Recover SQLDB to its original instance of SQL Server by using the DPM Administrator Console.

C.
Set the Recovery model option for SQLDB to Simple.Restore SQLDB to a network folder by using the DPM Administrator Console.

D.
Recover SQLDB to its original instance of SQL Server by using the DPM Administrator Console. Perform a consistency check for SQLDB.



Leave a Reply 0

Your email address will not be published. Required fields are marked *