[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-05-12
2
Medium Priority
?
1,329 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:luyan
  • 2
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 35748735
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
 
LVL 40

Expert Comment

by:lcohan
ID: 35748759
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question