You recieve the following error in EventViewer with regards to “MSSQL$SBSMONITORING”, Event ID: 1105
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 generally related to the size of the the database (Exceeds 4GB)
To Fix this follow the below instructions:
- Download this file and save in C Root
- Goto Start, Run, Type Services.msc
- Right Click on “SQL Server (SBSMONITORING)” and click stop
- Goto Directory contaning Databases in my case this is:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SBSMONITORING\MSSQL\DATA
- Go up a directory, and copy the Folder “DATA” to another location as a backup
- Go Back to services.msc and start database again.
- Open an elevated command prompt and type:
Sqlcmd -S %computername%\SBSMonitoring -E -i c:\updateSBSMonitoring.sql
- This can take more than 10 mins dependant on hardware and should display:
“Changed database context to ‘SBSMonitoring’ (1 rows affected)”
- This error should now be fixed, Restart server, assuming that no other SQL error occur with relation to the SBS Monitoring Database, Delete backup.
This article is a shortened version of: 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