Unable to Repair Issue in database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Unable to Repair Issue in database

Author

Topic

johnhocking
Starting Member

1 Post

Posted - 2010-10-12 : 13:59:24

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 removal 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 in index 'nc' (ID 2) does not match any data row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (1:831:36) with values (name = '_WA_Sys_00000016_3EC74557' and id = 1053246807) pointing to the data row identified by (id = 1053246807 and indid = 23).
CHECKDB found 0 allocation errors and 2 consistency errors in table 'sys.sysidxstats' (object ID 54).
Msg 8951, Level 16, State 1, Line 1
Table error: table 'nov_Files' (ID 501576825). Data row does not have a matching index row in the index 'IX_nov_FileName' (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:3902:39) identified by (FileId = 4195) with index values 'FolderID = 244 and FileName = 'DoYou_Bnr.jpg''.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'nov_Files' (ID 501576825). Index row in index 'IX_nov_FileName' (ID 2) does not match any data row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (1:7051:81) with values (FolderID = 244 and FileName = 'DoYop) pointing to the data row identified by (FileId = 4168).
CHECKDB found 0 allocation errors and 2 consistency errors in table 'nov_Files' (object ID 501576825).
CHECKDB found 0 allocation errors and 5 consistency errors in database 'novusint_repair2'.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-18 : 07:07:39

I know this is a very late reply, don't know how I missed this one. In case the OP is still around.

These errors are not repairable. You have damage to one of the more critical system tables.
Since there's no good backup, your options are limited to script all objects (and some may fail), export all data (and some likely will fail) and then recreate the database.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources