Use the Design pane to create a workflow of database maintenance tasks. Tasks can execute independent of another task's status, or can be dependent on another task's completion before they can begin execution.
You can add additional subplans in a maintenance plan to group related tasks or to schedule tasks to execute at different times.
To create a maintenance plan
Drag tasks to the Design pane to add them to the subplan. Double-click a task to specify its properties.
Tip: If you need to create several similar plans, you can simply copy existing plans or subplans and then make the necessary edits. Copy Maintenance Plans
Tip: For legacy maintenance plans only:
Task | Add this task to... | Available for legacy plans |
---|---|---|
|
Perform full or differential backups using the Fast Compression technology. NOTE: Fast Compression is only available with LiteSpeed 5.1 or later; Enterprise license. |
With LiteSpeed only |
|
Perform full, differential, or transaction log backups; with or without encryption. You can back up databases on multiple servers by adding a separate backup task to the maintenance plan for each server. |
Yes |
|
Validate the following:
|
Yes |
|
Defragment and compact existing indexes to improve performance. | With LiteSpeed only |
|
Execute an existing SQL Server Agent job. |
No |
|
Remove obsolete backup files and reports created by a maintenance plan. |
With LiteSpeed only |
|
Remove historical data from the msdb database and LiteSpeed Local and Central repositories for the following:
|
With LiteSpeed only |
|
Send an email notification to one or more existing operators. You can use the notification profiles only if they are already configured within a SQL Server instance. TIP: Variables defined in the maintenance plan can be used to format the Subject Line. There is also help information inside the task that lists the available Subject Line variables. NOTE: The SQL Server Agent must be configured to send email using Database Mail. Review the following for additional information: |
With LiteSpeed only |
Drop and recreate an index to improve performance. |
Yes | |
|
Reduce the size of data and log files in a database that grow beyond a specified size. |
Yes |
Execute statements or batches on one or more databases. NOTE: SSIS maintenance plans support only the Transact-SQL command type. |
Yes | |
Update column and index statistics. |
Yes |
(SSIS Plans only) Right-click a task to execute first and select Add Constraint to draw a line to the dependent task.
Tips:
NOTE: Constraints are not available for legacy plans. Legacy plan tasks are executed in the following sequence:
1. Clean Up History
2. Check Database Integrity
3. Rebuild Index
4. Shrink Database
5. Update Statistics
6. Reorganize Index
7. Fast Compression Backup or Back Up Database
8. Clean Up Maintenance Plans
9. Notify Operator
10. Execute T-SQL
(Optional) Set reporting options.
Reporting and Logging |
Click |
Notifications | Click |
Tips:
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center