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.
The following checklists provide recommended daily, weekly, and monthly maintenance tasks.
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 ...