[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1792
  • Last Modified:

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.
0
LostInWindows
Asked:
LostInWindows
  • 3
  • 2
1 Solution
 
RickEpnetCommented:
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

to

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 http://cid-6ca40dd0d4c9caa6.skydrive.live.com/self.aspx/.Public/sbsmonitoring.zip 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.
0
 
RickEpnetCommented:
This will replace your SBSMONITORING database with an empty one.
0
 
amol92952001Commented:
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.
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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?
0
 
RickEpnetCommented:
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?
0
 
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now