Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Whitepaper on interpreting CHECKDB results

Author  Topic 

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-10 : 12:36:40
Folks,

I'm going to write an advanced whitepaper on interpreting the results of CHECKDB in SQL Server 2005 (mostly applicable to SQL Server 2000 as well), should be available before end of the year. Couple of questions for you:

1) would this be interesting/useful to you?
2) anything in particular you'd like to see covered?

Thanks

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Kristen
Test

22859 Posts

Posted - 2005-08-10 : 15:00:38
1) Definitely
2) Well that depends on the corruption that I get

Perhaps some worked examples for how to get from a specific corruption report to a clean database?

For example:

o if CHECKDB hasn't been run for ages and all the backups are corrupted ...
o if dropping and recreating an index is all that is needed ...

Kristen
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-08-11 : 03:31:13
I would find it extremely useful (though hopefully not too often!). I agree with Kristen re: some useful examples


steve

Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.
Go to Top of Page
   

- Advertisement -