Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 932744 - Last Review: September 22, 2011 - Revision: 3.0
Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases
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
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.
Collapse this tableExpand this table
| Task | Safe to perform this task? |
|---|
| Check database | Yes |
| Reduce a database | Yes |
| Reorganize an index | Yes |
| Clean up the history | Yes |
| Update statistics | Yes. However, this task is unnecessary because the SharePoint Timer service performs this task automatically. |
| Rebuild an index | No. The task does not restore existing index options before the rebuild operation. However, you can use scripts that restore index options.
Note This problem was corrected in SQL Server 2005 Service Pack 2. |
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 "safe to perform," you are likely to experience increased performance in SQL Server 2005.
For more information about support for changes to the databases that are used by Microsoft Office server products and by Windows SharePoint Services, click the following article number to view the article in the Microsoft Knowledge Base:
841057Â
(http://kbalertz.com/Feedback.aspx?kbNumber=841057/
)
Support for changes to the databases that are used by Office server products and by Windows SharePoint Services
For more information about issues that occur in SharePoint Server 2007 or SharePoint Portal Server 2003 when you use the Rebuild index task in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:
930887Â
(http://kbalertz.com/Feedback.aspx?kbNumber=930887/
)
You experience issues with portal alerts in SharePoint Portal Server 2003 or with search performance in SharePoint Server 2007 after you create SQL Server 2005 maintenance plans
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
| kbinfo kbhowto kbexpertiseinter kbtshoot KB932744 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate