Friday, December 2, 2011

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:

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.

No comments: