[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2274
  • Last Modified:

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

0
doser
Asked:
doser
  • 2
1 Solution
 
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.
0
 
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:
TRUNCATE TABLE SysLog
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.
0
 
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now