Answers to Review Questions

  1. A. Only clustering offers an automatic failover solution.
  2. B. Because of the disk drive failure, you will have to restore the latest full database backup and last night's differential backup. Yes, you have lost all changes made to the database in the morning. The snapshot cannot be used because of the disk failure. The tail-log is unavailable because the database is using the SIMPLE recovery model.
  3. D. The tail-log should be backed up to ensure that no data has been lost. Only the READ_WRITE backup from last night needs to be restored. Then all transaction log backups after the READ_WRITE backup need to be restored. The tail-log needs to be restored last.
  4. C. A multi-instance cluster will allow the databases for the ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial