Microsoft KB Archive/932744

= Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases =

Article ID: 932744

Article Last Modified on 11/7/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007
 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Windows SharePoint Services 3.0
 * Microsoft Windows SharePoint Services 2.0

-



INTRODUCTION
This article contains information about the Maintenance Plan Wizard in Microsoft SQL Server 2005. This article also describes the tasks that you can perform in SQL Server 2005 if you are an administrator who manages databases in the following products:
 * Microsoft Office SharePoint Server 2007
 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Windows SharePoint Services 3.0
 * Microsoft Windows SharePoint Services 2.0



MORE INFORMATION
The Maintenance Plan Wizard in SQL Server 2005 enables administrators to perform the following maintenance tasks against SharePoint databases:
 * Check database integrity
 * Reduce a database
 * Reorganize an index
 * Clean up the history
 * Update statistics
 * Rebuild an index

We have tested these tasks and the effects that these tasks have on database schema and performance. The following table summarizes the results of these tests.

We used the following criteria to determine whether a task was safe to perform:
 * Whether the task modified the database schema from its default state
 * Whether the task decreased performance

Results may vary depending on the environment. However, if you use the Maintenance Plan Wizard to perform the tasks that are listed in the table as &quot;safe to perform,&quot; you are likely to experience increased performance in SQL Server 2005.

