– Predefined set of maintenance tasks on SQL Server instances
– Can be created using
- Maintenance plan wizard – straigh
- Maintenance Plan Design tab – gives few extra options and control over maintenace tasks.
– These are basically SQL Server agent jobs which are executed by SSIS packages.
– Following is a list of maintenance tasks that can be performed using maintenance plans
- Backup database task
- Check Database integrity task
- Execute SQL server agent job task
- execute tsql statement task
- history cleanup task
- maintenance cleanup task
- notify operator task
- rebuild index task
- reorganizes index task
- shrink database task
- update statistics task
Every maintenance task can be reproduced using TSQL – so creating your own maintenance jobs gives you more control and flexibility.
– Maintenance plans can be exported and imported to other severs.