>What DBCC CHECKDB reported? Are you running it daily to catch corruption immediately?
When I run it in our development environment, I get:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MyDatabase'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Those are the last two lines. Based on the first on the last two lines, if 0 allocation errors and 0 consistency errors have been found, it this the proper representation that everything is ok?
When I run it in our production environment, I get:
CHECKDB found 0 allocation errors and 4 consistency errors in database 'MyDatabase'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDatabase).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
...where I have this in one location:
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:24979) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
...and this in another location:
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:24979) allocated to object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data). Page (1:24979) was not seen in the scan although its parent (1:130354) and previous (1:120937) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data). Page (1:151301) is missing a reference from previous page (1:24979). Possible chain linkage problem.
There are 400007 rows in 14570 pages for object "MyTable".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'MyTable' (object ID 547533034).
How do we fix that?