Post reply

Script out Agent job to run DBCC CheckDB or Maintenance Plan Check DB Integrity Task?

  • April 3, 2013 at 5:40 am

    #292037

    Or is this a "six of one, half-a-dozen of the other" sort of question, which really will boil down to personal preference?

    From reading the MSDN description of the "Check DB Integrity" task, it sounds like it will do what DBCC CheckDB does, although possibly the "reporting" of problems might not be a "full featured" as from a custom script.

    Any thoughts?

    Beyond the obvious of "why aren't you already checking your DBs?"

    (Answer: I inherited the current situation, and am working on resolving stuff like this)

    Thanks,

    Jason

  • April 3, 2013 at 5:50 am

    #1603108

    Check Database integrity task runs CheckDB on the selected database. Functionally, it's the same as running CheckDB on that database from a custom job (reporting aside)

    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