SQL Express Database Too Big

Posted on 2008-11-13
Last Modified: 2012-06-22
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

Question by:doser
    LVL 24

    Expert Comment

    by:DBAduck - Ben Miller
    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.
    LVL 1

    Accepted Solution

    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.
    LVL 24

    Expert Comment

    by:DBAduck - Ben Miller
    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.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    PK numbers not follow 8 43
    does nexus 9k support nbar 5 53
    Stored procedure query with if 27 32
    Change variables in SQL table 6 54
    Introduction Many times we come across a slowness or instability between two hosts, and almost always we blame the poor networking guys, just because they're an easy target.  Sometimes we forget that other factors including disk bottlenecks, CPU …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now