How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)

The Maintenance Plan Wizard creates a maintenance plan that Microsoft SQL Server Agent can run on a regular basis. This allows you to perform various database administration tasks, including backups, run database integrity checks, or update database statistics at specified intervals.

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

  1. Expand the server.

  2. Expand the Management folder.

  3. Right-click Maintenance Plans and select Maintenance Plan Wizard. This launches the wizard and you can now step through and create a plan customized to meet your maintenance requirements.

See Also

Tasks

How to: Migrate SQL Server 2000 Database Maintenance Plans

Concepts

Maintenance Plan Wizard

Other Resources

Visual Database Tools How-to Topics

Help and Information

Getting SQL Server 2005 Assistance