The Maintenance Plan Wizard

The Maintenance Plan Wizard is a tool that is available in SSMS. It provides an automated means for creating the basic tasks needed to maintain a database. It does not include all the tasks available for use in a maintenance plan but is a great starting point that allows you to quickly generate the basic elements of a good plan.

You launch the Maintenance Plan Wizard by expanding the Management node in SSMS and then right-clicking Maintenance Plans and selecting Maintenance Plan Wizard. The Maintenance Plan Wizard is like most other Microsoft wizards in that it presents sequential dialog boxes that allow you to incrementally provide the information needed to create the wizard’s objective.

The Maintenance Plan Wizard ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.