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!
luyanAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
If you have NO other messages before the

"CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object."

errors you posted it may be that system objects are corrupted and that is the worst case scenario because I don't think they can be ever repaired so you may need to migrate all user tables/data into a brand new database.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.