You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance contains a database named CK_Prod that contains has a backup method which is as follows:
* CK_Prod is backed up to a file called CK_Prod.bak is performed at 08:00 hours each day.
* Transaction log backed up to a file called CK_Prod _HHMM.trn is executed every 20 minutes starting at 09:30 hours.
Furthermore, CK_Prod is configured in single-user mode. One morning at 09:40, a Domain.com
user named Mia Hamm stated that some information was removed by a search which was executed at 09:20.
You have received instructions to ensure that you recovery the database to its original status.
What should you do?
A.
You should consider using the following:
bak WITH NORECOVERY;
RESTORE LOG Product FROM “t:backups CK_Prod_0930.trn”
WITH RECOVERY, STOPAT = ‘Mar 8, 2010 09:20 AM’;
B.
You should consider using the following:
bak WITH NORECOVERY;
RESTORE LOG Product FROM “t:backups CK_Prod_0915.trn”
WITH RECOVERY, STOPAT = ‘Mar 8, 2010 09:20 AM’;
C.
You should consider using the following:
bak WITH NORECOVERY;
RESTORE LOG Product FROM “t:backups CK_Prod_0915.trn”
D.
You should consider using the following:
WITH RECOVERY, STOPAT = ‘Mar 8, 2010 09:20 AM’;
bak WITH STOPAT = ‘Mar 8, 2010 09:23 AM’;
Explanation:
There wouldn’t be any transaction log back at 9:15 to restore from. The backups are taken every
20 minutes from 09:30.