Link to home
Start Free TrialLog in
Avatar of luyan
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!
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial