Post reply

Correlation between suspect_pages and DBCC checkdb

  • January 29, 2018 at 9:36 am

    #328274

    Hello everyoneIs
    there anyone who can explain this scenario to me?
    if I connect on the table "suspect_pages" I have two lines that indicates the presence of the error 823 or 824 with an update of the column "last_update_date"
    If I run a dbcc checkdb on the base in question I have a positive feedback "CHECKDB found 0 allocation errors and 0 consistency errors in the database '******' '
    now will it be possible to have whom I must trust?
    Thanks

  • January 29, 2018 at 9:41 am

    #1977716

    Those suspect page entries are from several months ago. They could have been fixed, or regular maintenance such as index rebuilds could have made them disappear (an unallocated page cannot be said to be corrupt)

    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