Network Management

Back up the SolarWinds Orion database using SQL Server Management Studio

This article summarizes how to backup the SolarWinds Orion database using Microsoft SQL Server Management Studio (MS SSMS).

First published date

10/12/2018 1:09 PM

Last published date

6/2/2023 8:24 AM

Overview

This article describes how to backup the Orion database.

Note: By default, the name of the Orion database is SolarwindsOrion but you can change the name in the Configuration Wizard during the initial installation of Orion Platform products.

Product section

Orion Platform

Cause

N/A

Resolution

To back up the Orion database  

  1. In SQL Server Management Studio, connect to the appropriate instance of the Microsoft SQL Server Database Engine. 
  2. In Object Explorer, click the server name to expand the server tree.
  3. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
  4. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
  5. In the Database list box, verify the database name. You can optionally select a different database from the list.
  6. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).
  7. In the Backup type list box, select Full.
  8. Note that after creating a full database backup, you can create a differential database backup; for more information, see Create a Differential Database Backup (SQL Server).
  9. Optionally, you can select Copy Only Backup to create a copy-only backup. A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. For more information, see Copy-Only Backups (SQL Server).
  10. When the Differential option is selected, you cannot create a copy-only backup.
  11. For Backup component, click Database.
  12. Either accept the default backup set name suggested in the Name text box, or enter a different name for the backup set.
  13. Optionally, in the Description text box, enter a description of the backup set.
  14. Choose the type of backup destination by clicking Disk, Tape or URL. To select the paths of up to 64 disk or tape drives containing a single media set, click Add. The selected paths are displayed in the Backup to list box.