Operations Manager Database full (Management Server)
Posted on 2009-12-28
In the event log of the Essential Business Server's Management server, I noticed loads of errors coming from the MSSQL$SCE (System Center Essential's Operations Manager DB). Basically the errors are always the same like:
"Could not allocate space for object 'dbo.Event_51'.'idxc_Event_51_TimeAdded' in database 'OperationsManager' 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."
"CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database."
It seems that the DB has become too big. As far as I know the EBS Management Server is using the Desktop version of SQL 2005. What would you recommend to fix this?
- can I shrink the DB?
- is there another way except moving to the full version of MS SQL?
- if moving to the full version of MS SQL: are you aware of a how-to?