http://www.sqlservercentral.com/blogs/steve_jones/2012/10/01/database-maintenance-essentials-resources/ Printed 2016/05/24 02:35AM
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.
Filed under: Blog Tagged: administration, presentations, sql server, syndicated