Online Documentation for SQL Administrator for SQL Server

Maintenance plans


Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies.

Note: To create and edit maintenance plans a login must be a System Administrator role member.

 

Database Maintenance - Maintenance plans

 

 

SQL Server maintenance plans provide the following features:

  • Workflow creation using a variety of typical maintenance tasks. You can also create your own custom Transact-SQL scripts.
  • Conceptual hierarchies. Each plan lets you create or edit task workflows. Tasks in each plan can be grouped into subplans, which can be scheduled to run at different times.
  • Support for multiserver plans that can be used in master server/target server environments.
  • Support for logging plan history to remote servers.
  • Support for Windows Authentication and SQL Server Authentication. When possible, use Windows Authentication.

 

Use the context menu or buttons on the work area toolbar to manage the list of maintenance plans:

Create create a new maintenance plan

Edit edit selected maintenance plan

Drop drop selected maintenance plan

  • create the object copy on the same server
  • clone the object copy to another server

Execute execute selected maintenance plan

MaintenancePlanHistory view maintenance plan history

Print create and print the report

 

The list displays the existing maintenance plans as a grid with the following columns: Name, Folder, Application, Creation Date, Owner, Reader Role, Writer Role, Encrypted, Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

To open a Maintenance Plan in the Maintenance Plan Editor, double-click it in the grid. Alternatively, you can right-click the Maintenance Plan alias and select the Edit Login(s) context menu item.