Database Maintenance
Database maintenance involves different tasks. Because most of these tasks have been discussed in previous chapters, this section does not go into detail on 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 ... |
Get Microsoft® SQL Server™ 2005 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.
