dbcc checkdb error

Last Post 05 Apr 2010 01:05 PM by J013-B. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sqlserverdeveloper
New Member
New Member

--
05 Apr 2010 09:21 AM
On running dbcc checkdb, I got the below error, any ideas how to resolve this error, I need to find out the tables that have issues and should try to fix them. Any ideas. Thanks.

DBCC results for 'Database'. Msg 8979, Level 16, State 1, Line 1 Table error: Object ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data). Page (1:102726) is missing references from parent (unknown) and previous (page (1:51089)) nodes. Possible bad root entry in system catalog. CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysallocunits' (object ID 7). Msg 7995, Level 16, State 1, Line 1 Database 'Database': consistency errors in system catalogs prevent further DBCC checkdb processing. CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99). CHECKDB found 0 allocation errors and 2 consistency errors in database 'Database'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Below are the steps I did to try to resolve the error:
1. Switched the mode on the database to single user mode.

2. DBCC CHECKDB (Database,REPAIR_REBUILD) DBCC results for 'Database'. Msg 8979, Level 16, State 1, Line 1 Table error: Object ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data). Page (1:102726) is missing references from parent (unknown) and previous (page (1:51089)) nodes. Possible bad root entry in system catalog. The system cannot self repair this error. CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysallocunits' (object ID 7). Msg 7995, Level 16, State 1, Line 1 Database 'Database': consistency errors in system catalogs prevent further DBCC checkdb processing. CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99). CHECKDB found 0 allocation errors and 2 consistency errors in database 'Database'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.

3. DBCC CHECKDB (Database,REPAIR_ALLOW_DATA_LOSS) DBCC results for 'Database'. Msg 8979, Level 16, State 1, Line 1 Table error: Object ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data). Page (1:102726) is missing references from parent (unknown) and previous (page (1:51089)) nodes. Possible bad root entry in system catalog. The system cannot self repair this error. CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysallocunits' (object ID 7). Msg 7995, Level 16, State 1, Line 1 Database 'Database': consistency errors in system catalogs prevent further DBCC checkdb processing. CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99). CHECKDB found 0 allocation errors and 2 consistency errors in database 'Database'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
gunneyk
New Member
New Member

--
05 Apr 2010 12:23 PM
Well it appears that you have corruption in your system tables which means you will most likely have to restore from a last know good backup. But have a look at this:

http://blogs.msdn.com/psssql/archiv...enter.aspx
J013-B
New Member
New Member

--
05 Apr 2010 01:05 PM
Well, your error sounds like you cannot repair the error. As gunneyk said, you will have to restore from a backup.


Acceptable Use Policy
---