You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance. You can see the backup strategy utilized by the database from table listed
below: A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr;
you find that the batch process takes no effect because certain data is modified some data
by a user at 21:05 hr on the same day. The database should be recovered to its state at the
start of the batch process in the shortest time. Which action will you perform?
A.
The full database backup that was performed on Saturday should be recovered.
B.
The full database backup that was performed on Thursday should be recovered. And
then, all transaction logs should be recovered from the time of the full backup on Thursday
and should be stopped at 21:00 hr on Saturday.
C.
The full database backup that was performed on Thursday should be recovered. And
then the differential backup that was performed on Friday should be recovered. At last, all
transaction logs should be recovered from the time of the differential backup on Friday and
should be stopped at 21:00 hr on Saturday.
D.
The full database backup that was performed on Saturday should be recovered. And
then all transaction logs should be recovered from the time of the full backup on Saturday
and should be stopped at 21:00 hr on Saturday.