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: http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx
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.