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
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

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DBAduck - Ben MillerPrincipal ConsultantCommented:
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.
doserAuthor Commented:
Below is a solution I found elsewhere:

Truncate the table if you do not need to keep historical syslog messages
Open Database Manager
Start > All Programs > Solarwinds Orion > Database Utilities > Database Manager
If this is the first time you use the tool, add your database server by clicking on the Add server button.
Expand your database and right-click on the SysLog table.
Select Query Table.
Type the below SQL query:
and click on Refresh to execute the query.
This may take a while depending how many entries are recorded.
Once done, right-click on the database and select Compact Database.
Compacting a database shrinks it, reindexes it, and removes whitespace.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DBAduck - Ben MillerPrincipal ConsultantCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.