Database Maintenance Essentials – Resources

I told people in New York at SQL in the City that I’d post some resources on the blog from my talk. My apologies for not getting it done over the weekend, but during a little downtime in Austin I’m getting it done.


From the last slide, a checklist of things for you to look at on your instances.

    • Backups scheduled on all database (full and log)
    • DBCC CHECKDB running regularly on all databases
    • Test restores scheduled
    • Manage mdf/ndf/ldf file sizes
    • Proactively monitor and maintain indexes and statistics
    • Monitor jobs and set up alerts


At work, someday soon, but in the next 30 days, go through the checklist on your important servers, or all your production servers, and assess your maintenance.


From the slide deck, which will come soon in email. These are a list of links and resources from the talk.


About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , , . Bookmark the permalink.

1 Response to Database Maintenance Essentials – Resources

  1. Pingback: Comments on the SQL in the City Tour « Voice of the DBA

Comments are closed.