You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod.
The CK_Prod contains the following file groups:
* The PRIMARY file group that contains the On-Line Transaction Processing (OLTP) information that is kept in the reserved in the E: volume.
* A file group named CK_USERS that contains the older information that is kept in the F: volume.
* A transaction log of the information that is kept in the I: volume.
Data transferring occurs from the PRIMARY file group to CK_USERS, as a member of the archiving strategy for CK_Prod.
The backup of CK_Prod is as follows:
* The PRIMARY file group six times a day.
* The CK_USERS at 20:00
* The transaction log every 20 minutes
However, the volume that contains CK_USERS was lost at 14:00 hours. You have received
instructions to perform a recovery of CK_USERS with minimal data loss and in the shortest time as possible.
What should you do?
A.
You should consider backing up the transaction log and recovery the latest backup of
CK_USERS and recovery the entire transaction log backups after the most resent backup.
B.
You should consider backing up the transaction log and recovery the oldest backup of
CK_USERS and recovery the entire transaction log backups after the most resent backup.
C.
You should consider recovering the oldest backup of CK_USERS.
D.
You should consider recovering the latest backup of CK_USERS.