Home > database >  Sqlserver2008, DBCC checkdb database prompt more consistency error how to deal with
Sqlserver2008, DBCC checkdb database prompt more consistency error how to deal with

Time:09-25

Sqlserver2008, DBCC checkdb suggests multiple database consistency error, the diagram below:


Check is the data table [UFTmpTable_33565914_5231678149313212099] there is a problem, don't know how to generate, this watch is useless, tried to remove it prompts table does not exist or without permission;
Checklist sys. Objects, sys. Indexes, find sys. There is data in objects, but the sys. The indexes of no data, so the consistency of mistakes,
Trying to delete records from sysobjects, prompt "are not allowed at impromptu system directory updates,"

The search on the net, is probably said above sql2000 version does not support modifying system tables, really don't know how to deal with, the great god, please help to check it out!

CodePudding user response:

It seems not a table, and a statistical information, can consider to delete all the index and statistical information on the table, and then rebuild the index,

Note that the backup

CodePudding user response:

Is a table, I can find this in the resource manager table:


I try to check the table of statistics, check less than, index, fields are not easy, only have a record in table sysobjects:


I just want to delete this record, should not be consistency error!

CodePudding user response:

The alter database DbName set single_user with rollback immediate
Go
DBCC checkdb (DbName, repair_allow_data_loss)
Go
The alter database DbName set multi_user
Go
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Sql2000 above can also modify the system tables, just login with DAC
Suggest use DBCC to fix good

CodePudding user response:

DBCC checkdb (DbName, repair_allow_data_loss)
Is such repair, not line, an error, error is fixed times above

CodePudding user response:

If you try to auto repair,
Suggest a new empty database, the useful data import new database, then swap 2 database name.