Today one of the monitoring systems flagged up low disk space on a standalone Sharepoint box that’s hardly used, had a quick check and there was a database indeed using 150GB of space for about 30GB of content.  Strangely enough is was the Windows Internal Database.
Tried connecting via SQL Management Studio and it failed with errors.
After a bit of searching & some very confused SQL DBA’s the solution was to connect to a named pipe.

After changing the connection to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query it connected and I was able to shrink the database and bring it down to a much more manageable size.

If you’re using Server 2008 or newer make sure you run SQL Management Studio Express as Administrator

Connect on

Simon Treadaway

This blog is maintained by Simon Treadaway.Simon is a Senior Infrastructure Architect working in London, UK.
Connect on
Connect to Windows Internal Database

Leave a Reply

Your email address will not be published. Required fields are marked *