Errors generated by database consistency problems encountered by dbcc checkstorage are documented in the dbcc_types table. Most are in the ranges 5010–5024 and 100,000–100,038. For information on specific errors, see “dbcc_types” on page 1388 of the Reference Manual. dbcc checkstorage records two kinds of faults: soft and hard. For information, see “Comparison of soft and hard faults”.
Errors generated by database consistency problems encountered by dbcc commands other than dbcc checkstorage usually have error numbers from 2500 to 2599 or from 7900 to 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 database errors found by dbcc
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 are not used frequently, such as a table that is updated only monthly. dbcc can find, and often fix, these problems for you.
