Schedule DBCC Checkdb in SQL 2005 Express?

• Bex

  SSCrazy

  Points: 2437

  More actions

  November 17, 2015 at 8:28 am

  #313142

  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.

  Thanks

  Bex

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 17, 2015 at 8:30 am

  #1840364

  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

• Bex

  SSCrazy

  Points: 2437

  More actions

  November 17, 2015 at 8:37 am

  #1840368

  Thanks, Gail. I think I was just overthinking it.

  Bex