Tuesday 4 August 2009

SBS BPA: Reduce The Size of The SharePoint Configuration Databases

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:

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
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)

Windows Live Writer


Zalumo said...


I 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?


Anonymous said...

Realize this is a old post, just going to leave this here if anyone else gets the same error and runs across this:

I 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.