Errors generated by database consistency problems encountered by dbcc checkstorage are documented in the dbcc_types table. Most of the error numbers are in the ranges 5010 – 5024 and 100,000 – 100,038. For information on specific errors, see Chapter 2, “dbccdb Tables” in the Reference Manual: Tables.
Errors generated by database consistency problems encountered by dbcc commands other than dbcc checkstorage usually have error numbers from 2500 – 2599 or from 7900 – 7999. These messages, and others that can result from database consistency problems (such as Error 605), may include phrases like “Table Corrupt” or “Extent not within segment.”
Some messages indicate severe database consistency problems; others are not so urgent. A few may require help from Sybase Technical Support, but most can be solved by:
Running dbcc commands that use the fix option
Following the instructions in the Error Messages and Troubleshooting Guide, which contains step-by-step instructions for resolving many dbcc database errors.
Whatever techniques are required to solve the problems, the solutions are much easier when you find the problem soon after the occurrence of the corruption or inconsistency. Consistency problems can exist on data pages that used infrequently, such as a table that is updated only monthly. dbcc can find, and often fix, these problems for you.
