luyan
asked on
CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.
I ran - DBCC CHECKDB WITH NO_INFOMSGS, and got error message.
CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 10 consistency errors in database 'databasename'.
I set up database in single user mode, and did -
DBCC CHECKDB('databasename', REPAIR_REBUILD)
But still got same issue. Then I ran following Repair_allow_data_loss command. Sorry, still got the same issue.
DBCC CHECKDB (databasename, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
How to fix it?
Thanks!
CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 10 consistency errors in database 'databasename'.
I set up database in single user mode, and did -
DBCC CHECKDB('databasename', REPAIR_REBUILD)
But still got same issue. Then I ran following Repair_allow_data_loss command. Sorry, still got the same issue.
DBCC CHECKDB (databasename, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
How to fix it?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://ask.sqlservercentral.com/questions/5675/checkdb-found-0-allocation-errors-and-1-consistency-errors-not-associated-with-any-single-object
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/af6c16bf-10c1-45fd-af53-0889a641adc2/