Question of the Day for the MCTS 70-431 Exam: Implementing and Maintaining Microsoft SQL Server 2005
Show Question
| Q: | An error has occurred that has corrupted one of the databases on the server. The database is set to full recovery, the last full backup occurred last night, and log backups have been continuing on an hourly basis throughout the day. No differential backups are currently performed. What steps do you need to take to get the database up and running again with the least loss of data? (Choose all that apply.) |
| A: | A, D, E. To get the database back to as current a point as possible, you need to back up the log one final time to get any entries that have occurred from the last log backup to the point of the failure. You then need to restore the last full backup as a known point where the whole database was saved. To get the data as current as possible from that point, you need to restore all logs by specifying the STOPAT option to get a point-in-time restore to a moment just before the damage occurred. |
This question is from this book:
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
By Thomas Moore
Buy
Share This
Subscribe to This Newsletter
