Share via

dbcc checkdb : allocation vs consistency error

sakuraime 2,346 Reputation points
2021-07-24T14:09:00.697+00:00

if there are error from dbcc checkdb , what are the differences between allocation error and consistency error ?

SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 122K Reputation points MVP Volunteer Moderator
    2021-07-24T21:58:11.053+00:00

    In practice none. They are both errors that requires the database to be repaired, if possible, or restored from a clean backup. Originally, before SQL 7 or so, CHECKALLOC was a separate command.

    0 comments
  2. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-07-26T08:08:08.77+00:00

    Hi sakuraime,

    Please check this thread which might help:

    allocation errors have to do with errors in the way that pages are linked to objects, consistency errors have to do with the structure of a page.

    Best Regards,
    Amelia

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.