Maintenance Plan Wizard in SQL Server

Maintenance Plan Wizard in SQL Server

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

SQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize indexes, update statistics, backup databases and performs maintenance cleanup tasks etc. These maintenance tasks helps in keeping database health proper and functioning.

You can create maintenance plan for single server or multiserver and can schedule and run jobs on regular basis.

Following are the maintenance plan wizard tasks which you can create and perform.

-> Check Database Integrity

-> Shrink Database

-> Reorganize Index

-> Rebuild Index ->

Update Statistics

-> Clean Up History

-> Execute SQL Server Agent Job

-> Back Up Database (Full)

-> Back Up Database (Differential)

-> Back Up Database (Transactional Log)

-> Maintenance Cleanup Task

Here we will see step by step process for maintenance cleanup task and system database backups.

Once you will understand this process then you will be able to create other remaining tasks in the list also.

Basically this is four step process.

1. Create Maintenance Plan

2. Define Maintenance Cleanup Task

3. Define Back Up Database (Full) Task

4. Select Reporting Options