I'm running Solarwinds Orion on MS SQL Express 2005. The name of the database is NetPerfMon. I reached that 4GB limit and am now getting errors in Event Viewer such as the one I attached as code below. I do not have a SQL Server, so I can't move the database over. I want to somehow shrink down the size so I do not get any more errors. If I have to archive, then that's fine. Actually, whatever I have to do to fix this is fine.
I tried a few things. From Solarwinds, I changed statistics and events to delete from the database after 20 days and running a database maintanence. I also tried shrinking the database in SQL Server Management Studio after this, but that did not work. I tried compacting it in Solarwinds Database Manager, but that did not work. In SQL Server Management Studio, I went into the properties of the database and tried reducing the initial size, but that did not work; initial size is at 4096, which is the file size limit.
Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Could not allocate a new page for database 'NetPerfMon' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.