%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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
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/