SQL Server DBA

Common SQL Server Database Administration Tasks & Troubleshooting

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.

This is 23 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples