Link to home
Start Free TrialLog in
Avatar of doser
doserFlag for United States of America

asked on

SQL Express Database Too Big

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
Description:
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.

Open in new window

Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

SQL Express has  a physical limit of 4 GB so it will not grow larger.

In order to continue, you need to archive data and delete it or you have to use a full fledged SQL Server that is not Express.
ASKER CERTIFIED SOLUTION
Avatar of doser
doser
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can TRUNCATE your table, but the data goes away.  I am not sure how that is finding your own solution when we suggested that you archive your data and indicated to you that the database had a 4 GB limit.

But if that did not answer your question, I am glad that you got your answer, because that is why we are here is for Q&A not just questions.