SQL Maintenance for SharePoint Databases

SQL Maintenance for SharePoint Databases

Rate This
  • Comments 5

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/

Leave a Comment
  • Please add 2 and 1 and type the answer here:
  • Post
Page 1 of 1 (5 items)