Imagine that you are the systems administrator of your company and you are responsible for monitoring storage performance and capacity using SolarWinds Storage Manager. Suddenly there is a power outage at the company. Once power is restored, you find out that your database is either destroyed or corrupted. One way to avoid this issue is to perform a backup of your data. There are couple of quick ways to back up the Storage Manager database. Both will be explained below.

 

Performing a manual backup of the database:

 

1. Shutdown the mariadb service. This will also shut down all the other Storage Manager related services

 

2. Locate your database

 

  • Windows default location

 

  • Linux default location

 

3. Make a copy of the storage folder and place it in a safe location

 

4. Start the mariadb service and any other Storage Manager related services. The Storage Manager services are:

 

  • SolarWinds Storage Manager Collector
  • SolarWinds Storage Manager Event Receiver
  • SolarWinds Storage Manager Maintenance
  • SolarWinds Storage Manager Poller
  • SolarWinds Storage Manager Web Services

 

Running the DButil script:

 

Storage Manager ships with a script that will make backups of your database and even comes with the added feature of running maintenance routines to help keep the database running smoothly. This script can be automated to run regularly using Windows task scheduler in Microsoft Windows or crontab if you are running Linux. The user must make sure there is ample space in the destination folder he wishes to back up the Storage Manger database to.

 

Dbutil runs the following procedures:

 

  • Backup – Copies the database to a backup directory specified by the user
  • Maintenance – Runs database repair, analysis, and optimization procedures

 

Preparation to run dbutil in Windows:

  1. The default location of dbutil in Windows is %Program Files%\SolarWinds\Storage Manager Server\bin
  2. Using a text editor, edit your dbutil.bat file and find the following string: “Set BackupStage=C:\temp\mariadb_backup“
  3. Change the path to the directory where you would like to back up your Storage Manager database.

Note: It is recommended that you do not use a directory within the Storage Manager install directory.

Preparation to run dbutil in Linux:

  1. The default location of dbutil in Linux is /opt/Storage_Manager_Server/bin
  2. Using a text editor, edit your dbutil.sh file and find the following string: export backupStage=/opt/mariadb_backup
  3. Change the path /opt/mariadb_backup to the directory where you would like to back up your Storage Manager database.

Note: It is recommended that you do not use a directory within the Storage Manager install directory.

Usage of dbutil:

  • Windows - dbutil.bat [backup|maintenance]
  • Linux -  dbutil.sh [backup|maintenance]

More information can be found here for running dbutil.