Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nudais
Starting Member
2 Posts |
 Posted - 2011-05-14 : 18:39:25
|
| I wonder if someone could clear something up for me? There's a question in the practice exam which came with this book which goes like this:The backup schedule for your database is as follows:Full backup @ 1AM every FridayDifferential backup @ 1AM Saturday thru ThursdayTransaction log backup every hour on the hour.On Tuesday at 3:25AM the database crashes. Which of the following do you need to do to restore data?From a bunch of options available, the answer is: Restore Friday backupRestore Tuesday backupRestore 2AM transaction logRestore 3AM transaction logRestore 4AM transaction logI picked all the above EXCEPT the last item, but according to the book I'm wrong. So, my question is, if the database crashed at 3:25AM (so presumably went down and stayed down), how did it manage to perform the 4AM transaction log backup which (according to the book) you're supposed to restore as the last step in the recovery process? Surely the last backup it could have performed was the 3AM transaction log backup? What am I missing?I think the book's wrong, but then I would wouldn't I? ;-)Thanks for your help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-14 : 19:35:11
|
| Normally we don't answer exam questions, even practice exam questions, but if you investigate "tail log backups" and Paul Randal's blog, you'll find an answer. It may be documented in Books Online too (check there first) |
 |
|
|
|
|
|
70-431 MS Press Book Mock Exam Question