PrepAway - Latest Free Exam Questions & Answers

what should you do to restore the database to its origin state while using the minimal time?

You are the administrator of your company network. There’s a SQL Server 2008 instance which hosts a large database in your company. The database uses the following backup strategy. On Saturday you execute a batch process, this process lasts from 21:00 to 22:50. Since a user has modified some data at 21:03 on the same day, the batch process is invalidated. So what should you do to restore the database to its origin state while using the minimal time?

PrepAway - Latest Free Exam Questions & Answers

A.
You should restore the full database backup which was performed on Saturday.

B.
You should restore the full database backup which was performed on Thursday. Restore all transaction logs from the time of the full backup on Thursday and

C.
You should 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

D.
You should 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.


Leave a Reply