SBS 2008 Monitoring Database Fills to Capacity

On one of my SBS 2008 boxes, I began getting a ton of messages in my event log about the SBS 2008 monitoring database filling to capacity. You'll see events like this:

Log Name: Application

Source: MSSQL$SBSMONITORING

Date: 12/16/2009 4:15:47 PM

Event ID: 1827

Task Category: (2)

Level: Error

Keywords: Classic

User: SYSTEM

Computer: xxx.xxx.com

Description:

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

Log Name: Application

Source: MSSQL$SBSMONITORING

Date: 12/16/2009 4:15:47 PM

Event ID: 1105

Task Category: (2)

Level: Error

Keywords: Classic

User: SYSTEM

Computer: xxx.xxx.com

Description:

Could not allocate space for object 'dbo.EventLog'.'PK_EventLog' in database 'SBSMonitoring' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

This is resolved by using this process:

http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx

The description of the fix doesn't match the problem, but it works.

VERY IMPORTANT - this will make the SBSMonitoring_log.ldf very, very large. In my case, it made that file 30 GB, which ate up almost all the space on my C drive, which was a huge problem. See my next post on how to fix that.