SBSMonitoring database is full

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.
Who is Participating?
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.
This will replace your SBSMONITORING database with an empty one.
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;

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

LostInWindowsAuthor Commented:
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?
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?
LostInWindowsAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.