Question
DBCC CHECKDB reports corruption during a scheduled integrity check; what is the recovery runbook?
Answer
1. Preserve CHECKDB output. 2. Identify the last clean backup. 3. Restore to a separate database. 4. Validate with DBCC CHECKDB. 5. Restore production from clean backups; use REPAIR_ALLOW_DATA_LOSS only as last resort.