O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required