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

Speaker: Mikael Wedham

Duration: 60 minutes

Track: 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.

Accompanying Material

No material found.

Back to Top