SBSMonitoring  database is full

Posted on 2012-09-13
Last Modified: 2012-09-16
I have SBS 2008 and SQL Server Express 2005. The problem that I have is that the database is full. The logfile is fine but the database itself is full.

I have googled a lot and I have found that the PowerShell Script found at: doesn't work because the db is full.

I queried the status of the database and it says Recovery_Pending.

If I follow the steps to replace the database with an empty one from SkyDrive the SBSMonitoring service doesn't stay running.

Help!! how do I get an empty database? Is there a query that I can run to empty the data from this one?

This thing is driving me crazy. IT seems like so many solutions should work but this isn't happening for me.
Question by:LostInWindows
    LVL 14

    Accepted Solution

    1. Run services.msc.

    2. Stop the Datacollectorsvc service(Windows SBS Manger Service), SQL Server(SBSMONITORING) service (To be able to unlock monitoring database files)

    3. Change the name of those 2 files in case you will use them in the future:

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring.mdf

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring_log.ldf


    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring-bak.mdf

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring_log-bak.ldf

    4. Download file.

    5. Unzip the zip file and copy those two files to C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ folder

    Note: you don’t need to do detach or attach database in SQL Management Studio. And that database has already been tuned by the SQL command above.

    6. Start the SQL Server(SBSMONITORING) service

    7. Start the Datacollectorsvc service(Windows SBS Manger Service)

    For more information on the beginning part of this article, you can refer to this article:

    SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash.
    LVL 14

    Expert Comment

    This will replace your SBSMONITORING database with an empty one.

    Expert Comment

    Even I had the same issue and solved by the same steps mentioned above.
    but if your database of SBS is approching the size limit yhen you can try this link;

    LVL 1

    Author Comment

    I tried replacing the database with an empty one as you suggested. When I restart SQL Server SBS Monitoring it starts and stops immediately with the usual message that you would see in the services window about sometimes services are supposed to do this. I felt that this message was incorrect and the SQL Server should keep running.

    Every run into this before? Should I consider a reboot between replacing the database and restarting the service?
    LVL 14

    Expert Comment

    You might try re-booting but when I did not I did not need to re-boot. Did you stop both services when you replace the database?
    LVL 1

    Author Closing Comment

    I tried this four times before I posted the question. Fifth time lucky. I don't know what I did differently but I am so glad it worked.<br />Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now