Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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

SQL Express database is over xx% full

Created by Karen Valdellon_ret, last modified by carolyn.mazenko on Jun 26, 2018

Views: 8,084 Votes: 4 Revisions: 4

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 2016 and 2017: 10 GB
  • 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