Solved

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

Posted on 2012-12-30
3
672 Views
Last Modified: 2012-12-30
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
Comment
Question by:tgreendyk
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
Julian123 earned 500 total points
ID: 38731105
Microsoft has a KB on how to shrnk that DB with a script you can use: http://support.microsoft.com/kb/2000544.
0
 
LVL 1

Author Comment

by:tgreendyk
ID: 38731411
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
 
LVL 1

Author Closing Comment

by:tgreendyk
ID: 38731417
Ignore previous comment...I forgot that I'd stopped the WINS service!

Worked like a charm.

Thanks!

Tom
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now