70-450 · Question #103
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…
The correct answer is D. Restore the full database backup that was performed on Thursday. The backup just before the batch takes 90 minutes to complete. The full backup will grab any recently completed transactions as it nears completion, so most- if not all-of the batch modifications will be included. It's necessary to go back further than that. Lesson: don't run…
Question
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?
Exhibit
Options
- ARestore the full database backup that was performed on Saturday.
- BRestore the full database backup that was performed on Thursday
- CRestore the full database backup that was performed on Saturday.
- DRestore the full database backup that was performed on Thursday.
How the community answered
(22 responses)- A5% (1)
- B5% (1)
- C14% (3)
- D77% (17)
Explanation
The backup just before the batch takes 90 minutes to complete. The full backup will grab any recently completed transactions as it nears completion, so most- if not all-of the batch modifications will be included. It's necessary to go back further than that. Lesson: don't run major changes during your backups.
Topics
Community Discussion
No community discussion yet for this question.