Post reply

updatestats job

  • September 28, 2008 at 3:25 pm

    #878209

    They will affect any query that tries to use the corrupt pages. Update stats (unless used with fullscan) samples pages, so it may or may not be affected, depending which pages it reads.

    You need to fix the corruption. Any query that tries to read damaged pages is going to get a very high severity error and will probably be disconnected. Your database cannot be trusted at this point.

    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

  • September 28, 2008 at 3:32 pm

    #878211

    But today it got succeeded when we reran the Job after 6 hours of Job failure.

    Thank You.

    Regards,
    Raghavender Chavva

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

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