Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > SQL Express database is over xx% full

SQL Express database is over xx% full

Created by Karen Valdellon, last modified by MindTouch on Jun 23, 2016

Views: 1,660 Votes: 3 Revisions: 3

Overview

This article provides a workaround and a permanent resolution when the following error is encountered:

SQL Express database is over xx% full

Environment

All Orion Core products that use the SQL Server Express database

Cause 

SQL Server Express databases are limited in size:

  • SQL Server Express 2008 R2 and higher: 10 GB
  • SQL Server Express versions earlier than 2008 R2: 4 GB

Resolution

  1. Create a back up of the database.
  2. Restore the database to a Full Standard/Enterprise SQL Server.
  3. Run the Configuration Wizard and point to the new SQL Server.

As a workaround, create some space in your SolarWinds database by deleting unnecessary objects. You can remove your Traps and Syslog to gain space.

 

More detailed instructions on migrating your database are outlined here:

https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/Migrate_Orion_NPM_database_from_the_Orion_server_to_a_separate_SQL_database_server

 

 

Last modified

Tags

Classifications

Public