Submit a ticketCall us
Home > Success Center > Storage Manager (STM) > SRM Profiler Administrator Guide > SRM Profiler database > Database Maintenance using Dbutil

Database Maintenance using Dbutil

Updated: June 16, 2017

Dbutil is a script that ships with SRM Profiler and allows you to make backups of your database and run maintenance routines to keep the database running smoothly.

All SRM Profiler Services are halted when this utility runs.

Depending on which platform you are running, directions are below explaining how to run dbutil in your environment.

Run dbutil in Windows

The dbutil.bat file is located in the <installed drive>:\Program Files\SolarWinds\Storage Manager Server\bin directory.

Preparation

  1. Using a text editor, edit your dbutil.bat file and find the following string: Set BackupStage=C:emp\mariadb_backup
  2. Change the path C:emp\mariadb_backup to the directory where you would like to backup your profiler database.

: It is recommended that you do not use a directory within the SRM Profiler install directory and you need to verify that the location selected has sufficient free disk space for your database.

Usage

dbutil.bat [backup|maintenance]

Options

  • backup: Copy database to backup directory
  • maintenance: Run database repair/analysis/optimization procedures
  • default (no options specified): Executes maintenance and backup

Scheduling

To run this using Windows task scheduler.

  1. Open Windows Task Scheduler and Create a Basic Task with your desired schedule (Weekly for example).
  2. Set the Action as Start a Program.
  3. Program/script = \bin\dbutil.bat
  4. Set the arguments to "backup" to only do a backup if desired.

Run dbutil in Linux

The dbutil.bat file is located in the <installed drive>/Storage_Manager_Server/bin directory.

Preparation

  1. Edit your dbutil.sh file and find the following string: export backupStage=/opt/mariadb_backup
  2. Change the path /opt/mariadb_backup to the directory where you would like to backup your profiler database.

: It is recommended that you do not use a directory within the SRM Profiler install directory and you need to verify that the location selected has sufficient free disk space for your database.

Usage

dbutil.sh [backup|maintenance]

Options

  • backup: Copy database to backup directory
  • maintenance: Run database repair/analysis/optimization procedures
  • default (no options specified): Executes maintenance and backup

Scheduling

Create a cron job to run the dbutil.sh on a schedule.

 
Last modified

Tags

Classifications

Public