Maintenance Plans

Maintenance Plans

-------------------------------------

Maintenance Plan Tasks are:

• Check Database Integrity Task

The Check Database Integrity task performs internal consistency checks of the data and index pages within the database.

• Backup Database Tasks(full)

The Back Up Database (Full) task allows you to specify the source databases, destination files or tapes, and overwrite options for a full backup.

• Backup Database Tasks(Differential)

The Back Up Database (Differential) task allows you to specify the source databases, destination files or tapes, and overwrite options for a differential backup.

• Backup Database Tasks(Transaction Log)

The Back Up Database (Transaction Log) task allows you to specify the source databases, destination files or tapes, and overwrite options for a transaction log backup.

• Execute SQL Server Agent Job Tasks

The Execute SQL Server Agent Job task allows you to select SQL Server Agent jobs to run as part of the maintenance plan.

• Execute T-SQL Statement Task
• History Cleanup Task

The History Cleanup task deletes historical data about Backup and Restore, SQL Server Agent, and Maintenance Plan operations.  This wizard allows you to specify the type and age of the data to be deleted.

• Maintenance Cleanup Task
• Notify Operator Task
• Rebuild Index Task

The Rebuild task reorganizes data on the data and index pages by rebuilding indexes. This improves performance of index scans and seeks. This task also optimizes the distribution of data and free space on the index pages, allowing faster future growth.

• Reorganize Index Task

The Reorganize Index task defragments and compacts clustered and non-clustered indexes on tables and views. This will improve index-scanning performance.

• Shrink Database Task

The Shrink Database task reduces the disk space consumed by the database and log files by removing empty data and log pages.

• Update Statistics Task

The Update Statistics task ensures the query optimizer has up-to-date information about the distribution of data values in the tables. This allows the optimizer to make better judgments about data access strategies.