Export (0) Print
Expand All
Expand Minimize

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

Updated: 12 December 2006

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.

  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.

Community Additions

ADD
Show:
© 2014 Microsoft