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: 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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RickEpnet
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;
http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx.
Thanks.
but if your database of SBS is approching the size limit yhen you can try this link;
http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx.
Thanks.
ASKER
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?
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?
ASKER
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.