Maintenance Plan Wizard

Home Up


 

Step 1 - Invoke Maintenance Plan Wizard

Step 2 - Start Page

Step 3 - Target Server

Step 4 - Select Maintenance Tasks

Step 5 - Select Task Order

 

Step 6a - Define Shrink Database Task

Step 6b - Select Database(s)

Step 6c - Define Shrink Database Task (end)

Step 7 - Define Database Integrity Check Task

Select Database(s) would follow

Step 8 - Define Reorganize Index Task

Select Database(s) would follow

Step 9 - Define Rebuild Index Task

Select Database(s) would follow

Step 10 - Define Update Statistics Task

Select Database(s) would follow

Step 11 - Define Execute SQL Server Agent Job Task

Step 12 - Define Full Database Backup Task

Select Database(s) would follow

Step 13 - Define Differential Database Backup Task

Select Database(s) would follow

Step 14 - Define Back Up Database (Transaction Log) Backup Task

Select Database(s) would follow

Step 15 - Define Cleanup History Task

Step 16a - Select Plan Properties

Step 16b - Select Plan Properties,
Change Button
(New Job Schedule dialog box)

Step 16c - Select Plan Properties
(Completed)

Step 17 - Select Report Options

Step 18 - Complete the Wizard

(This gives the opportunity to go backward in the wizard before processing.)

Step 19 - Maintenance Plan Wizard Progress