We have seen some mention made of the SharePoint configuration databases getting quite large.
To date, we did not see any simple way to reduce the size of those databases.
Microsoft Support has released a Knowledgebase article with a simple SQL based script to trim the database size:
- Microsoft KB 2000544: SBS 2008 BPA Reports that The Windows SharePoint Services configuration databases log file is getting large (currently over 1gb in size)
- SBS 2008 Best Practices Analyzer (BPA) (download page)
Make sure to run a full backup just before running the script. This will enable a quick recovery of the server if things go sideways.
Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book
*All Mac on SBS posts will not be written on a Mac until we replace our now missing iMac! (previous blog post)
Phil,
ReplyDeleteI have copied the code and run the command according to the MS article but I receive an error:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
So how do I allow SQL to allow remote connections on SBS2008?
Cheers
Jeremy
Realize this is a old post, just going to leave this here if anyone else gets the same error and runs across this:
ReplyDeleteI found copying and pasting the command for some reason was changing the text, specifically it was changing the beginning portion "\\.\pipe\mssql" to "\\.\pipemssql"
Manually tying the command in worked fine.