SQL Maintenance for SharePoint Databases

Published 02-08-2019 12:40 PM 137 Views
Microsoft

First published on MSDN on Aug 27, 2008

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/

%3CLINGO-SUB%20id%3D%22lingo-sub-333177%22%20slang%3D%22en-US%22%3ESQL%20Maintenance%20for%20SharePoint%20Databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2027%2C%202008%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20already%20know%2C%20you%20can't%20treat%20SharePoint%20databases%20like%20any%20other%20database%20in%20regards%20to%20SQL%20Server.%20Here's%20a%20listing%20of%20articles%20that%20talk%20to%20what%20you%20can%20do.%20Before%20doing%20any%20maintenance%2C%20PLEASE%20read%20these%20articles.%20Index%20fragmentation%20is%20a%20big%26nbsp%3Bhotspot%20for%20alot%20of%20SQL%20DBAs.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDatabase%20maintenance%20for%20Office%20SharePoint%20Server%202007%20(white%20paper)%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262731.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262731.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20to%20defragment%20Windows%20SharePoint%20Services%203.0%20databases%20and%20SharePoint%20Server%202007%20databases%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F943345%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F943345%20%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInformation%20about%20the%20Maintenance%20Plan%20Wizard%20in%20SQL%20Server%202005%20and%20about%20tasks%20that%20administrators%20can%20perform%20against%20SharePoint%20databases%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F932744%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F932744%2F%20%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20experience%20issues%20with%20portal%20alerts%20in%20SharePoint%20Portal%20Server%202003%20or%20with%20search%20performance%20in%20SharePoint%20Server%202007%20after%20you%20create%20SQL%20Server%202005%20maintenance%20plans%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F930887%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F930887%20%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESupport%20for%20changes%20to%20the%20databases%20that%20are%20used%20by%20Office%20server%20products%20and%20by%20Windows%20SharePoint%20Services%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F841057%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F841057%2F%20%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-333177%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20MSDN%20on%20Aug%2027%2C%202008%20If%20you%20don't%20already%20know%2C%20you%20can't%20treat%20SharePoint%20databases%20like%20any%20other%20database%20in%20regards%20to%20SQL%20Server.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-333177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERonGrzywacz%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Apr 28 2020 11:42 AM
Updated by: