Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Performance Monitor (NPM) > DB - SQL Move

DB - SQL Move

Table of contents

Updated March 29th, 2016

Overview

SQL - DB Move

Environment

  • NPM

Steps

The procedure for migrating an Orion database to another server is straight-forward.

The basic steps are :

  1. Create a full backup of your SQL database on the current SQL server.
  2. Move the backup file(*.bak) to the new SQL server.
  3. Restore the backup file on the new SQL server.

 

To complete the migration, run the Configuration Wizard on the Orion server:

  1. Click Start -> Programs -> Solarwinds Orion -> Configuration and Auto-Discovery -> Configuration Wizard. Select Database, Services and Website.
  2. When prompted for database, enter the details of the new SQL server and use SQL authentication.
  3. Enter the sa account and password for the new SQL server, click Next. Select Use Existing Database and select the restored database from the drop-down menu. Click Next.
  4. Select Create a New account and enter the details for a new SQL account which the Orion services and Website will use when connecting to the SQL server. The Configuration Wizard will create this SQL account automatically on the SQL server.
  5. Click Next, accepting the defaults for the remainder of the Configuration Wizard.
  6. Once completed, the Orion will be using the restored database on the new SQL server.

 

Resources:

 

 

Last modified
11:11, 4 Apr 2017

Tags

Classifications

Public