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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.