Schedule DBCC Checkdb in SQL 2005 Express?

  • I've just inherited a number of SQL Server 2005 Express installations. Whilst I am able to schedule backups for them using scripts/windows scheduler (there is no scope for installing any tools), can I schedule DBCC CheckDB to run?

    If anyone can point me to any existing scripts (Google is failing me), I would very much appreciate it.



  • Honestly, much the same way you do the backups, a script to run checkDB and the windows scheduler.

    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
  • Thanks, Gail. I think I was just overthinking it.


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

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