>>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?

See http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-EMERGENCY-mode-repair-the-very-very-last-resort.aspx