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.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2010-02-12 : 22:30:03
|
| I am getting the below errors when I run dbcc checkdb on my Database, please let me know how I can resolve these errors. Thanks.DBCC results for 'Database'.Msg 8979, Level 16, State 1, Line 1Table 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 1Database '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. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-13 : 02:59:33
|
| " Database 'Database': consistency errors in system catalogs prevent further DBCC checkdb processing."I expect that is terminal.First find and fix the hardware fault that caused the problem. Check the SQL Error Log and the system Event log looking for any error messages.If the DB is in Full recovery model take a final TLog backupRestore the most recent Full backup to a NEW TEMPORARY database (can be on a different machine if you want to do it at the same time as sorting out the hardware fault on the main server)Run DBCC CHECKDB to check that it is cleanIf not revert to restoring an earlier Full backup until you find one that is cleanStarting with that clean, full, backup restore it and then all subsequent TLog backups (including the final one you just made)Run DBCC CHECKDB, if not clean then one/some of the TLog backups are corrupted too. Restore to a point in time, DBCC CHECKDB, if clean restore to a later point in time.Once you have a clean database either repeat the steps on the Live database, or take a Full backup on the Temporary database and restore to Live |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
|
|
dbcccheck db errors