Post reply

Patching runs DBCC checkdb

  • May 31, 2013 at 3:07 pm

    #275893

    Hi Team,

    I have a cluster environment and I am going to apply the patches in the passive first, reboot passive and failover from the resources from the active to passive. When i do the failover, does SQL Server run DBCC Checkdb on the passive node before bringing the databases online?

    Thanks,

    Karthik R

  • May 31, 2013 at 3:23 pm

    #1620236

    IIRC, DBCC CHECKDB is not run automatically by SQL Server. If you need this run you need to do it manually or using a scheduled process.

  • May 31, 2013 at 4:17 pm

    #1620242

    The only time when CheckDB is run on a database is when a user, application or job explicitly runs CheckDB.

    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

  • May 31, 2013 at 4:21 pm

    #1620243

    GilaMonster (5/31/2013)

    The only time when CheckDB is run on a database is when a user, application or job explicitly runs CheckDB.

    Yea! I got one right today.

Viewing 4 posts - 1 through 3 (of 3 total)

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