A DBA's Guide to the Proper Handling of Corruption

on YouTube ↗53m

" summary

Explains how to detect and respond to physical file corruption using only built‑in SQL Server tools: SQL Agent alerts, the suspect_pages table, DBCC CHECKDB (use ALL_ERRORMSGS and NO_INFOMSGS), and scripted alerts for severity ≥19 plus error 825. Emphasizes tested restores over snapshots or relying on AGs, warns that running REPAIR_ALLOW_DATA_LOSS without Microsoft guidance can silently drop data, shows index disable/rebuild and when a restore is the only safe option.

AI-written summary · about

" chapters (16)

1. 0:00Introduction and speaker background
2. 1:27What is database corruption
3. 7:12Monitoring corruption with SQL tools
4. 13:13Using CHECKDB effectively
5. 16:34Repair ALLOW_DATA_LOSS risks
6. 20:05Backup and restore strategies
7. 24:03Virtualization and backup misconceptions
8. 26:37Clusters and availability groups
9. 28:03Incident management process
10. 30:55First steps during corruption
11. 33:06Assessing corruption impact
12. 34:29Demo: Index corruption recovery
13. 37:42Demo: TempDB corruption recovery
14. 38:23Demo: Unknown corruption case
15. 45:55Demo: System page corruption
16. 51:11Summary and Q&A

" related talks

• 51mDatabase in Distress: Testing and Repairing Different Types of Database CorruptionJosef Machytka · PostgreSQL Conference Europe 2025
• 21mSQL Horror StoriesKevin Kline · SQLBits 2019
• 52mData Corruption Bugs: Diagnosis and LessonsNoah Misch · PGConf.dev 2024
• 20mDebugging Data Corruption in PostgreSQLPalak Chaturvedi · PGConf.dev 2025
• 37mDatabase in Distress: Testing and Repairing Different Types of Database CorruptionJosef Machytka · PGDay Lowlands 2025
• 32mDebugging Data Corruption in PostgreSQL: A Systematic ApproachPalak Chaturvedi, Nitin (mentioned) · POSETTE: An Event for Postgres 2025
• 39mData Corruption: Stop the Evil TribblesBetsy Haibel · RailsConf 2017
• 01mAre you an "accidental" DBA?Percona Live 2022