SBSMonitoring is too large

Problem:

SBSMonitoring DB is way too large. The autoclean process of Windows sometimes malfunctions, go figure.

Solution 1:

To expedite the process, I would first stop the SQL SBS service.

When you run the command, make sure you preface it with .\

http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx

Solution 2:

1. Stop the SQL SBS service first
2. Go to C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
3. Rename the files to a .bak or something
4. Download and unzip the following files into the same directory sbsmonitoring
5. Start the service
6. Delete the files after a couple of days or at least move them elsewhere if you have a space issue

Update

Optional:

  1. Open IIS
  2. Drill down until you have Default Web Site selected
  3. In the features view (center selection), scroll down until you see Logging (Health and Diagnostics)
  4. Double click on Logging
  5. Click on Disable