O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

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

Designing a Database Maintenance Plan

At the database level, the DBA has to design an appropriate database maintenance plan. Long gone are the days of a DBA being responsible for only database consistency checks and backups.

It is important to choose the appropriate tool when designing your database maintenance plan. SQL Server 2005 offers two main options via the SQL Server Management Studio (SSMS) environment.

The Maintenance Plan design surface provides a “free-form” environment where you can place maintenance objects on the design surface and subsequently link them through various types of evaluation operations and precedence.

The Database Maintenance Plan Wizard, as with all wizards other than Harry Potter, offers a number of choices through ...

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