Hi Gail and Paul

Thanks for the reply. I restored from our backup and ran DBCC CHECKDB with NO_INFOMSGS again and we still have corruption:

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (1:1515894). The PageId in the page header = (0:2).

CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.

Msg 8928, Level 16, State 1, Line 1

Object ID 181575685, index ID 255: Page (1:1515893) could not be processed. See other errors for details.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 181575685, index ID 255, page (1:1515893). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.

Msg 8928, Level 16, State 1, Line 1

Object ID 181575685, index ID 255: Page (1:1515894) could not be processed. See other errors for details.

CHECKDB found 0 allocation errors and 3 consistency errors in table 'cq.attachments_blob' (object ID 181575685).

CHECKDB found 0 allocation errors and 4 consistency errors in database 'sysdevcq'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (sysdevcq ).

I will now go back to tape to get an earlier backup. In the meantime I'm going to attempt a repair on the current DB.

cheers