Post reply

Allocation and consistency Error

  • May 8, 2012 at 8:56 am

    #273737

    Hello Guys,

    What are allocation and consistency error ? To which object they are related to? I mean what caused this errors? And how we can get rid from this errors ?

  • May 8, 2012 at 9:04 am

    #1484582

    Allocation errors are errors relating to how pages are owned by various objects. Consistency errors are errors relating to pages that are incorrect.

    Both are usually the result of IO subsystem problems.

    There's no simple answer and no single solution. Is this academic interest or an actual problem?

    If academic interest, take a look at this article. http://www.sqlservercentral.com/articles/65804/

    If an actual problem, please run the following and post the full and complete results

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply