Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Orion Database appears offline

Orion Database appears offline

Created by Marjune Obana, last modified by MindTouch on Jun 23, 2016

Views: 15 Votes: 0 Revisions: 10

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
23:16, 22 Jun 2016

Tags

Classifications

Public