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
Simon Treadaway
This blog is maintained by Simon Treadaway.Simon is a Senior Infrastructure Architect working in London, UK.
Latest posts by Simon Treadaway (see all)
- Add replicas on Exchange 2010 Public Folders - 25/08/2016
- Remove all aliases for a domain in Office 365 - 24/08/2016
- Installing Exchange 2010 SP3 Rollups on Server 2012 - 12/07/2016
Connect to Windows Internal Database