Post reply

Schedule DBCC Checkdb in SQL 2005 Express?

  • 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

  • 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

  • November 17, 2015 at 8:37 am

    #1840368

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

    Bex

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

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