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
 DBCC CheckDB error code list

Author  Topic 

lugosviz
Starting Member

1 Post

Posted - 2010-04-21 : 10:09:37
Helo!

Could you give me a DBCC Cehck DB error code list (code, code description, code group, etc.)?
Exactly, I would like to know which error code what does mean.
Maybe it's enought the error code "groups".

Thx

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-04-21 : 11:50:36
I believe there's one in the book SQL Server 2008 Internals, in the chapter written by Paul Randal.

Is this an academic question, or do you have corruption? If you do, please post the output of checkDB. While I don't know error numbers off by heart, I have a fair understanding of what the errors mean.

This may also be worth a read - [url]http://www.sqlservercentral.com/articles/65804/[/url]

--
Gail Shaw
SQL Server MVP
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2010-04-21 : 12:03:19
The book chapter doesn't have the list in - there's no published list of them all anywhere. It's on my list to do...

Paul S. Randal,
Managing Director, SQLskills.com
Blog: www.SQLskills.com/blogs/paul Twitter: twitter.com/PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of SQL 2005 DBCC CHECKDB/repair code
Go to Top of Page
   

- Advertisement -