You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you.
And 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.
And 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.