Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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