Command:
1 | DBCC CHECKDB |
Returned:
1 2 3 4 5 6 7 8 9 10 11 12 | DBCC results for 'AP_TypeLocations'. There are 3004 rows in 14 pages for object "AP_TypeLocations". Msg 8976, Level 16, State 1, Line 1 Table error: Object ID 1028198713, index ID 5, partition ID 72057594296467456, alloc unit ID 72057594306560000 (type In-row data). Page (1:441793) was not seen in the scan although its parent (1:403571) and previous (1:441792) refer to it. Check any previous errors. Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 1028198713, index ID 5, partition ID 72057594296467456, alloc unit ID 72057594306560000 (type In-row data). Page (1:441794) is missing a reference from previous page (1:441793). Possible chain linkage problem. Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 1028198713, index ID 5, partition ID 72057594296467456, alloc unit ID 72057594306560000 (type In-row data), page (1:441793). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4. Msg 8928, Level 16, State 1, Line 1 Object ID 1028198713, index ID 5, partition ID 72057594296467456, alloc unit ID 72057594306560000 (type In-row data): Page (1:441793) could not be processed. See other errors for details. DBCC results for 'TX_Transactions'. There are 5825069 rows in 50944 pages for object "TX_Transactions". |
To correct:
1 2 3 | ALTER DATABASE [AIMS] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DBCC CHECKDB(N'AIMS', REPAIR_ALLOW_DATA_LOSS); ALTER DATABASE [AIMS] SET MULTI_USER; |