Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

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

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
0
tgreendyk
Asked:
tgreendyk
  • 2
1 Solution
 
Julian123Commented:
Microsoft has a KB on how to shrnk that DB with a script you can use: http://support.microsoft.com/kb/2000544.
0
 
tgreendykAuthor Commented:
Thanks, Julian123.

I can't seem to get the script to run, though. I get the error in the attached screen shot. How can I allow remote connections when I can't get into SQL Server Management Studio?

Thanks!

Tom
SharepointLogDB2.jpg
0
 
tgreendykAuthor Commented:
Ignore previous comment...I forgot that I'd stopped the WINS service!

Worked like a charm.

Thanks!

Tom
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now