What should you do?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales and product data. The CK_Sales database has three file groups named Primary, Secondary and Extra. Primary is the primary file group and contains the critical data from the database.
A Full backup of the CK_Sales database is performed every Saturday at 12:00 P.M., and a backup of the transaction log is performed every two hours during the working day. Certkiller -DB01 suffers a catastrophic failure. You replace Certkiller -DB01 with a new SQL Server 2005 database server named Certkiller -DB02. You now need to restore the Primary filegroup from a backup named bak_20060722 as quickly as possible. The Secondary and Extra file groups will be restored later.
What should you do?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales and product data. The CK_Sales database has three file groups named Primary, Secondary and Extra. Primary is the primary file group and contains the critical data from the database.
A Full backup of the CK_Sales database is performed every Saturday at 12:00 P.M., and a backup of the transaction log is performed every two hours during the working day. Certkiller -DB01 suffers a catastrophic failure. You replace Certkiller -DB01 with a new SQL Server 2005 database server named Certkiller -DB02. You now need to restore the Primary filegroup from a backup named bak_20060722 as quickly as possible. The Secondary and Extra file groups will be restored later.
What should you do?

A.
Run RESTORE DATABASE CK_Sales FILEGROUP=’Primary’ FROM bak_20060722 WITH PARTIAL, NORECOVERY

B.
Run RESTORE DATABASE CK_Sales FILEGROUP=’Primary’ FROM bak_20060722 WITH PARTIAL

C.
Run RESTORE DATABASE CK_Sales FILEGROUP=’Primary’ FROM bak_20060722

D.
Run RESTORE DATABASE CK_Sales FILEGROUP=’Primary’ FROM bak_20060722 WITH NORECOVERY

Explanation:
You need to perform a partial restore and then apply the transaction log backups. You must include the NORECOVERY option to be able to apply the transaction log backups.
Incorrect Answers:
B: You must include the NORECOVERY option to be able to apply the transaction log backups.
C: You need to perform a partial restore and then apply the transaction log backups. This means you must use the PARTIAL option and the NORECOVERY option to be able to apply the transaction log backups.
D: You must use the PARTIAL option to perform a partial backup.



Leave a Reply 0

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