Backup of dbWatch

When we think about backup of dbWatch, this involves several different parts of the software and installation:

dbWatch Server and configuration files

dbWatch Server is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and C:\Program Files (x86)\dbWatch\[version] on Windows.

A zip of this directory is sufficient for backing up the dbWatch Server installation.
There are no registry keys for which the dbWatch Server depends on, but if you move the zip file to a new server, it is important that on Windows you add a new service to start dbWatch.

While we do recommend our customers do a complete backup of the installation directory, a few configuration files are essential and unique to your installation. The most important ones are server_configuration.xml, autentication.xml and authorization.xml.

They contain the information for all the databases you are monitoring and the privileges for your operators. Keep them safe. They are located in the dbWatch Server root directory.

Other files, path relative to dbWatch Server root directory, you might want to keep are:

Your license key file: server/license/license

Any changed tasks files you might have: server/resources/tasks_local/

Any notes you might have: server/resources/notes/

Any changed management scripts you might have: server/resources/admin_specifications_local/

Any changed report_templates: server/resources/global_report_local/

Edited extentions config: server/extensions/edited_configurations/

dbWatch Monitor and config files

dbWatch Monitor is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and C:\Program Files (x86)\dbWatch\[version] on Windows.
A zip of this directory is sufficient for backing up the dbWatch Monitor installation. There are no registry keys that the dbWatch Monitor depends on.

While we do recommend our customers do a complete backup of the installation directory, a few configuration files are essential and unique for your installation. The most important one is monitor.xml. This contains the information about the dbWatch Servers you connect to. This is located in the dbWatch Server root directory.

dbWatch Schema in the databases

dbWatch Schema is usually called “dbwatch” and can be dumped with a command such as exp/imp on Oracle. It is also normally backed up as part of the normal database backup. In the dbWatch Schema all information on which tasks are installed, their status and historic information is kept. If you lose this, you can remove the database from dbWatch, drop the dbWatch user if it exists from the database and then add the database in dbWatch again. You will be without some historic information, but you get the database monitored by dbWatch again, and that is what is most important.

← Troubleshooting / Restore dbWatch configuration backup →