Maintenance Plan Wizard F1 Help

The following topics provide help on the Maintenance Plan Wizard.

To create or manage maintenance plans, you must be a member of the sysadmin fixed server role. Object Explorer only displays the Maintenance Plans node for users who are members of the sysadmin fixed server role.

To start the Maintenance Plan Wizard

  • In SQL Server Management Studio, in Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Maintenance Plans.

Maintenance Plan Wizard

Maintenance Plan Wizard (Complete the Wizard Page)

Maintenance Plan Wizard (Define Backup Database Differential Task Page)

Maintenance Plan Wizard (Define Backup Database Full Task Page)

Maintenance Plan Wizard (Define Backup Database Transaction Log Task Page)

Maintenance Plan Wizard (Define Database Check Integrity Task Page)

Maintenance Plan Wizard (Define Execute SQL Server Agent Job Task Page)

Maintenance Plan Wizard (Define History Cleanup Task Page)

Maintenance Plan Wizard (Define Maintenance Cleanup Task Page)

Maintenance Plan Wizard (Define Rebuild Index Task Page)

Maintenance Plan Wizard (Define Reorganize Index Task Page)

Maintenance Plan Wizard (Define Shrink Database Task Page)

Maintenance Plan Wizard (Define Update Statistics Task Page)

Maintenance Plan Wizard (Maintenance Plan Wizard Progress Page)

Maintenance Plan Wizard (Select Maintenance Task Order Page)

Maintenance Plan Wizard (Select Maintenance Tasks Page)

Maintenance Plan Wizard (Select Plan Properties Page)

Maintenance Plan Wizard (Select Report Options Page)

Maintenance Plan Wizard (Select Target Servers Page)

Maintenance Plan Wizard (Starting Page)

Change History

Release History

12 December 2006

Changed content:
  • Removed requirement to install SSIS.
  • Added requirement that user must be a member of the sysadmin fixed server role to create and manage maintenance plans, and to view the Maintenance Plans node in Object Explorer.

5 December 2005

New content:
  • Added requirement to install SSIS.