SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Database Creation and Design How-to Topics
Databases How-to Topics
How to: Add Data or Log Files to a Database (SQL Server Management Studio)
How to: Attach a Database (SQL Server Management Studio)
How to: Change the Configuration Settings for a Database (SQL Server Management Studio)
How to: Create a Database (SQL Server Management Studio)
How to: Create User-Defined Data Types (SQL Server Management Studio)
How to: Delete a Database (SQL Server Management Studio)
How to: Delete Data or Log Files from a Database (SQL Server Management Studio)
How to: Detach a Database (SQL Server Management Studio)
How to: Display Data and Log Space Information for a Database (SQL Server Management Studio)
How to: Generate a Script (SQL Server Management Studio)
How to: Increase the Size of a Database (SQL Server Management Studio)
How to: Move a Database Using Detach and Attach (Transact-SQL)
How to: Rename a Database (SQL Server Management Studio)
How to: Set a Database to Single-user Mode (SQL Server Management Studio)
How to: Shrink a Database (SQL Server Management Studio)
How to: Shrink a File (SQL Server Management Studio)
How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)
How to: Upgrade a Database Using Detach and Attach (Transact-SQL)
How to: View a Database (SQL Server Management Studio)
How to: View or Change the Recovery Model of a Database (SQL Server Management Studio)
How to: View a List of Databases on an Instance of SQL Server (SQL Server Management Studio)
How to: View the Dependencies of a Table (SQL Server Management Studio)
How to: View the Settings for a Database (SQL Server Management Studio)
Expand Minimize
2 out of 9 rated this helpful - Rate this topic

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

SQL Server 2005

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.