Microsoft Technology Guru Contest Round 2 – Question # 33

You are a database administrator for your company. You review the error log for a SQL Server 2005 Enterprise Edition computer. You notice torn page errors for one index in a 2-terabyte (TB) database. You need to resolve the torn index page problem as quickly as possible. What should you do?

A. Run DBCC CHECKDB with the REPAIR_REBUILD option.
B. Use the latest database tape backup to restore only the torn page. Then restore any transaction logs that have been made since the full backup.
C. Restore the latest full tape database backup. Then restore any transaction logs that have been made since the full backup.
D. Restore the database from the most recent database snapshot.

 

How to participate:

  • Answer the above question and providing your email address along.
  • Only the answer provided with email address will be marked.
  • Only the first correct answer will be considered.
  • For further details kindly refer to the Competition Rules and Guidelines.