SQL Maintenance for SharePoint Databases


If you don’t already know, you can’t treat SharePoint databases like any other database in regards to SQL Server. Here’s a listing of articles that talk to what you can do. Before doing any maintenance, PLEASE read these articles. Index fragmentation is a big hotspot for alot of SQL DBAs.


Database maintenance for Office SharePoint Server 2007 (white paper)
http://technet.microsoft.com/en-us/library/cc262731.aspx


How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases
http://support.microsoft.com/kb/943345


Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases
http://support.microsoft.com/kb/932744/


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
http://support.microsoft.com/kb/930887


Support for changes to the databases that are used by Office server products and by Windows SharePoint Services
http://support.microsoft.com/kb/841057/

Comments (5)

  1. SQL Maintenance for SharePoint Databases SharePoint databases are NOT like any other database in regards…

  2. Michal Bojko says:

    If someone would be intersted, you can see possible improvement results on typical actions in SharePoint after using proposals from Microsoft.

    http://www.starsoft.com.pl/en/files/Windows%20SharePoint%20Services%20Content%20Databse%20performance%20results.pdf

  3. Scott says:

    Hello, are you going to write anything on sharepoint 2010 and db perf and maint?

Skip to main content