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.