Command:
DBCC CHECKDB
Returned:
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".
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:
ALTER DATABASE [AIMS] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CHECKDB(N'AIMS', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [AIMS] SET MULTI_USER;
DBCC CHECKDB(N'AIMS', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [AIMS] SET MULTI_USER;