PrepAway - Latest Free Exam Questions & Answers

You need to restore the database to its state at the start of the batch process in the least possible time

You administer a SQL Server 2008 instance that hosts a database. The backup strategy
used by the database is as shown in the following table. You run a batch process on
Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is
invalidated because a user has modified some data at 21:05 hr on the same day. You need
to restore the database to its state at the start of the batch process in the least possible
time. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Restore the full database backup that was performed on Thursday. Restore the
differential backup that was performed on Friday. Restore all transaction logs from the time
of the differential backup on Friday and stop at 21:00 hr on Saturday.

B.
Restore the full database backup that was performed on Saturday.

C.
Restore the full database backup that was performed on Thursday. Restore all
transaction logs from the time of the full backup on Thursday and stop at 21:00 hr on
Saturday.

D.
Restore the full database backup that was performed on Saturday. Restore all
transaction logs from the time of the full backup on Saturday and stop at 21:00 hr on
Saturday.


Leave a Reply