Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Archive > 2018Jan2 - Deletes > Orion Database appears offline

Orion Database appears offline

Created by Marjune Obana, last modified by Kevin.Swinson on Jan 02, 2018

Views: 959 Votes: 0 Revisions: 11

Overview

This article provides brief information and steps to resolve the issue when the user is unable to access the Orion Database. 

The following error appears: 

Error: Alter failed for Database 'SolarWindsOrion'.
Database 'SolarWindsOrion' cannot be opened due to inaccessible files or insufficient memory or disk space'

Environment

All NPM versions

Resolution

Note: Create a backup of your database before proceeding with the following steps.

1. Open SQL Management Studio and log in with administrative privileges.

2. The queries below should set the database to EMERGENCY and single user mode. You have to run the query one at a time and check for results.

EXEC sp_resetstatus 'SolarWindsOrion'
ALTER DATABASE SolarWindsOrion SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC Check ('SolarWindsOrion', REPAIR_ALLOW_DATA_LOSS)

 

ALTER DATABASE SolarWindsOrion SET MULTI_USER
ALTER DATABASE SolarWindsOrion SET SINGLE_USER
DBCC CheckDB ('SolarWindsOrion', REPAIR_REBUILD)
ALTER DATABASE SolarWindsOrion SET MULTI_USER

orion_database_appears_offline_1.png

 

This should set the database back to normal and you can move forward in truncating tables that have the most disk space like "Syslog, Traps or TrapVarbinds".

See Clear Orion NPM Database space for more information.  

3. Run the database maintenance

Cause

The issue occurs when the SQL server disk space is full or the SQL database is either locked or offline. 

orion_database_appears_offline_2.png

Last modified

Tags

Classifications

Public