SQL Maintenance Plan

One, Maintenance Plan Wizard

1. Start the Maintenance Plan Wizard

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/145751584.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/145810496.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/145818321.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

2. Change plan

In the, click on the "Change" button below to go to the "Job Schedule Properties" dialog window.

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/150120446.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

　　Note : This plan will only take effect if the "enabled" option is checked in the upper right corner.

After you change the plan, the OK button below the point returns to the Maintenance Plan Wizard.

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/150406507.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

3. Add Scheduled Tasks

In the Select Maintenance Task window, some common maintenance tasks are listed.

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/150537554.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

　　Note : Reorganize index (reorganize) is not the same as Rebuild index (rebuild).

Then select the order in which the maintenance tasks are executed.

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/150933730.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

4. Configure each task

For example:

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151259529.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151341713.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

5. Complete Maintenance Plan

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151507608.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151517268.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151524193.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

Second, view maintenance plan

1. Confirmation of Completion

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151743504.png "style=" padding:0px; Margin:0px;vertical-align:top;border:none; "/>

2. View or modify the plan

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/151945800.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

III. implementation of maintenance plans

1. Automatic execution

The Maintenance Plan Wizard has created a job, and the SQL Server Agent service will automatically run the job as scheduled.

2. Manual execution

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/152422564.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

3. View history

650) this.width=650; "border=" 0 "src=" http://img1.51cto.com/attachment/201305/152713144.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border:none; "/>

This article is from the "We have chased the MSSQL" blog, keep this source http://jimshu.blog.51cto.com/3171847/1007058

SQL Maintenance Plan