troubleshooting Question

Windows SBS 2008 Sharepoint log DB - unable to access via Management Studio

Avatar of tgreendyk
tgreendyk asked on
Microsoft SharePointSBS
3 Comments1 Solution709 ViewsLast Modified:
Hi All,

I have a client with a Windows 2008 SBS that is dangerously low on disk space. I can see that the Sharepoint Log DB is taking up about 25% of the disk space and I need to shrink the DB. Normally that's an easy thing -- I'd just open SQL Server Management Studio, select the database and click Shrink.

However, in this case I'm not able to open the DB using the SQL Server 2005 Managment Studio Express that's installed. When I select the #MICROSOFT###SSEE database and try to open it using WIndows authentication, I get the error in the attached screen shot.

Sharepoint is not in use at this client -- it just came as part of the SBS installation.

I can also see using Services that it's not listed as a SQL process, but is a Windows Internal Database (WINS).

How can I recover this wasted disk space?

Thanks in advance for the responses.

Tom
SharepointLogDB.jpg
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros