Database Maintenance
Database maintenance involves different tasks. Most of these tasks have been discussed in previous chapters; this section does not go into detail about tasks already covered. Instead, there is a checklist that you can use as a starting point for your maintenance efforts. The rest of the section explains how to set up maintenance plans and run database consistency checks.
Database Maintenance Checklist
The following checklists provide recommended daily, weekly, and monthly maintenance tasks.
Daily
✓ | Monitor application, server, and agent logs. |
✓ | Configure alerts for important errors that are not configured for alert notification. |
✓ | Check for performance and error alert messages. |
✓ | Monitor job status, particularly jobs that back up databases ... |
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
