This post describes the way I used the Microsoft SQL Server 2005 Maintenance Plan Wizard.
When none default values are used, they will be listed below.
> To create a Microsoft SQL Server 2005 Maintenance Plan follow the steps:
> Start Microsoft SQL Server Management Studio
> On the Connect to Server Dialog:
Server type: Database Engine
ServerName: you’re servername like 127.0.0.1\ONTW
Authentication: Windows Aythentication
Click on Connect
> Expand Mangement in the Object Explorer
> Right click Maintenance Plans
> Choose Maintenance Plan Wizard
> On the Maintenance Plan Wizard dialog,
Enter a name
Enter description
Select “Single schedule for the entire plan or no schedule”
Click on Change … to change the schedule for example:
Enter a name
Occurs: Daily
Occurs once at: 13:00:00
Click on OK
Click on Next
> On the “Select Maintenance Tasks” dialog
Select “Check Database Integrity”
Select “Reorganize Index”
Select “Rebuild Index”
Select “Update Statistics”
Select “Clean Up History”
Select “Maintenance Cleanup Task”
Click on Next
> On the “Select Maintenance Task Order” dialog
Click on Next
> On the “Define Database Check Integrity Task” dialog
Select you’re database
Click on OK
Click on Next
> On the “Define Reorganize Index Task” dialog
Select you’re database
Click on OK
Click on Next
> On the “Define Rebuild Index Task” dialog
Select you’re database
Click on OK
Click on Next
> On the “Define Update Statistics Task” dialog
Select you’re database
Click on OK
Click on Next
> On the “Define History Cleanup Task” dialog
Click on Next
> On the “Define Maintenance Cleanup Task” dialog
Select Maintenance Plan text reports
Choose a folder (same as the folder in the following dialog)
Click on Next
> On the “Select Report Options” dialog
Write a report to a text file
Click on Next
> On the “Complete the Wizard” dialog
Click on Finish
> On the “Maintenance Plan Wizard Progress” dialog
Click on Close