When good pages go bad / The rise and fall of db corruption.

Mikael Wedham
60 minutes
Enterprise Database Administration & Deployment
We'll walk through how to detect and repair corruption in a database. The DBCC command is the most important part and its output will be covered. The different methods to repair the pages gives different amounts of data loss, so we'll go through some of your options such as page level restore, DBCC repair options and some other options. Finally you'll learn to estimate how much data loss you can expect. We'll even going to see how to look at the corrupt page with DBCC PAGE to try to see approximately what data we are going to loose.
Familiarity with SQL Server backup/restore. Conceptual understanding of database files and internal database structures.

Accompanying Material

No material found.

Back to Top cage-aids