O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

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

Chapter 16. Introduction to the Maintenance Plan Designer

So far in this book, we have spent a lot of time learning how to use the Maintenance Plan Wizard to create a Maintenance Plan. We've investigated each of the eleven different maintenance tasks it can perform, and discussed how to configure and schedule each task, explaining the many settings that are available for each task.

Along the way, we discovered that much of the power of the Wizard stems from its simplicity. If you want to create a Maintenance Plan that runs a defined set of maintenance tasks the same way for a given set of databases, then the Wizard is a very powerful tool.

However, with its simplicity come certain limitations. One or two of the tasks, notably the Maintenance Cleanup ...

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