Home
%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%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2027%2C%202008%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%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%3CBR%20%2F%3E%3CP%3EDatabase%20maintenance%20for%20Office%20SharePoint%20Server%202007%20(white%20paper)%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262731.aspx%22%20mce_href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262731.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262731.aspx%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EHow%20to%20defragment%20Windows%20SharePoint%20Services%203.0%20databases%20and%20SharePoint%20Server%202007%20databases%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F943345%22%20mce_href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F943345%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F943345%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%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%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F932744%2F%22%20mce_href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F932744%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F932744%2F%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%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%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F930887%22%20mce_href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F930887%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F930887%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESupport%20for%20changes%20to%20the%20databases%20that%20are%20used%20by%20Office%20server%20products%20and%20by%20Windows%20SharePoint%20Services%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F841057%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F841057%2F%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-333177%22%20slang%3D%22en-US%22%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%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-333177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edatabase%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%202003%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%202007%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%20server%202007%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ewss%202%200%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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/