OK, so I tried running DBCC CHECKDB('DB',REPAIR_ALLOW_DATA_LOSS) on my problem DB (the copy, NOT production!)
Here's what I get back, again, snippets, it goes on for lines and lines and lines...
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8943937187254829056 (type Unknown), page (50944:61452520). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -1.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8943937187254829056 (type Unknown), page (50944:61452520). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -1.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8797764540885368832 (type Unknown), page (9292:-2034823424). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -14.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8797764540885368832 (type Unknown), page (9292:-2034823424). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -14.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8593334470942720000 (type Unknown), page (33625:2524159). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8593334470942720000 (type Unknown), page (1:146392). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8574653514900897792 (type Unknown), page ID (1:146302) contains an incorrect page ID in its page header. The PageId in the page header = (45544:-2072670773).
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8572601868255363072 (type Unknown), page (15158:2094676946). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
...
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:157206) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:157207) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 5, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page (1:157208). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 6, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page (1:157208). Test ((m_type >= DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 0.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 7, Line 2
...
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8502670685410099200 (type Unknown), page ID (1:146345) contains an incorrect page ID in its page header. The PageId in the page header = (59398:-62535944).
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8603375161530122240 (type Unknown), page (1:779640). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9043239549262299136 (type Unknown), page (1104:-16684543). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -10.
Repairing this error requires other errors to be corrected first.
CHECKDB found 0 allocation errors and 1951 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
There are 2710 rows in 54 pages for object "sys.sysrscols".
...
DBCC results for 'sys.sysclsobjs'.
Msg 8939, Level 16, State 5, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page (1:146176). Test (m_headerVersion == HEADER_7_0) failed. Values are 77 and 1.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 7, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page (1:146176). Test (m_freeData >= PageHeaderOverhead () && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 8, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page (1:146176). Test (m_freeCnt <= PAGESIZE - PageHeaderOverhead ()) failed. Values are 0 and -20430.
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page ID (1:146186) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page ID (1:146285) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), page ID (1:146327) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Repairing this error requires other errors to be corrected first.
There are 20 rows in 1 pages for object "sys.sysclsobjs".
CHECKDB found 0 allocation errors and 6 consistency errors in table 'sys.sysclsobjs' (object ID 64).
...
DBCC results for 'AllDocStreams'.
Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057594043957248 (type LOB data). The off-row data node at page (1:40486), slot 0, text ID 1500446720 is not referenced.
Repairing this error requires other errors to be corrected first.
Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057594043957248 (type LOB data). The off-row data node at page (1:42455), slot 1, text ID 1412169728 is not referenced.
Repairing this error requires other errors to be corrected first.
Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057594043957248 (type LOB data). The off-row data node at page (1:43029), slot 1, text ID 694353920 is not referenced.
Repairing this error requires other errors to be corrected first.
Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057594043957248 (type LOB data). The off-row data node at page (1:43257), slot 1, text ID 373882880 is not referenced.
Repairing this error requires other errors to be corrected first.
Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057594043957248 (type LOB data). The off-row data node at page (1:43641), slot 0, text ID 1121386496 is not referenced.
Repairing this error requires other errors to be corrected first.
Msg 8964, Level 16, State 1, Line 2
...
Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057612423528448 (type In-row data): Errors found in off-row data with ID 842727424 owned by data record identified by RID = (1:1035791:22)
Repairing this error requires other errors to be corrected first.
Msg 8929, Level 16, State 1, Line 2
Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057612423528448 (type In-row data): Errors found in off-row data with ID 2038890496 owned by data record identified by RID = (1:1035794:30)
Repairing this error requires other errors to be corrected first.
Msg 8929, Level 16, State 1, Line 2
Object ID 293576084, index ID 1, partition ID 72057611895439360, alloc unit ID 72057612423528448 (type In-row data): Errors found in off-row data with ID 606928896 owned by data record identified by RID = (1:1035795:8)
Repairing this error requires other errors to be corrected first.
There are 22440 rows in 726 pages for object "AllDocStreams".
CHECKDB found 0 allocation errors and 2924 consistency errors in table 'AllDocStreams' (object ID 293576084).
Any help would be appreciated, I suppose even a "yep, you're b0ned" response...
😉
Thanks all.
Jason