checkdb found issues with one of the databases
The issue has been going on longer then we have current backups, so restoring a backup will not fix the issue.
I have tried running the repair in both safe mode and data loss mode but neither process repaired anything.
I even tried scripting the removial of the foriegn keys and the primary key affected and adding them back to try and fix it but the issue is the same.
Does anyone know of anything else I can try or any tech docs to discuss how to fix this?
Here are the error messages from checkdb
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3855, State 1: Attribute (data_space_id=1) exists without a row (object_id=1053246807,index_id=24) in sys.indexes.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'sys.sysidxstats' (ID 54). Data row does not have a matching index row in the index 'nc' (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:7120:26) identified by (id = 1053246807 and indid = 23) with index values 'name = '_WA_Sys_00000016s3EC74557' and id = 1053246807'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'sys.sysidxstats' (ID 54). Index row
View Complete Post