Why you should backup IPNetwork monitoring database

Backup your monitoring database to prevent data loss

Q: Do I need to backup IPNetwork monitoring database? A: Every backup copy decreases risk of data loss. Please note that every hardware device will fail sooner or later, that includes memory chips, storage devices (such as hard disks, solid-state drives etc), and so on. OS and/or software bugs, as well as power failures may lead to database becoming inconsistent. Unless you make backup copies, you risk losing part of or entire monitoring database content. Below we list several recommendations generally applicable to every information you do not wish to lose. For better chances to prevent data loss, please take into account all the pieces of advice.

1. Upgrade to the latest IPNetwork version

IPNetwork Monitor includes DB Maintenance settings section, allowing to fine tune automated monitoring DB backup, with possibility to restore manually one of good backups. The above configuration is set, by default, to keep 3 good copies of monitoring database. Since backup copies are created on daily basis, that allows to restore from a good backup 1-3 days old, in case monitoring database gets irreversibly damaged. If you have enough disk space, we recommend setting the amount of good backups kept to 7-14; for busy and/or big monitoring setups that improves chances to have recent enough backup at hand, should you need to restore it. Note: the latest IPNetwork releases do also handle various security-related issues, so we strongly discourage you from using out-of-date software.

2. File(s) to backup

Below we leave directions on what file(s) you need to backup. Please note that if you plan to backup monitoring database file itself, the below steps should be performed first:
  • stop IPNetwork monitoring service: either from GUI client’s “Tools” menu, or from “Control panel > Administrative tools > Services”
  • stop IPNetwork Monitor GUI client, if it is running
  • open Task Manager window, choose Processes/Details (depending on Windows version) and check whether firebird.exe process is running; if it does, terminate it
You should backup whatever files located in “Backup to” field in “Settings > DB Maintenance” window. Note: by default, primary DB database file (nms.fdb) location is used as “Backup to…” location. If you need to copy the primary file, please stop IPNetwork monitoring, as explained above. Note you can safely copy other files with names starting with ‘nms.gbak_’.

2.1. After you copied all the files

If you had to stop IPNetwork monitoring service, please run it again after the backup files have been copied. Start IPNetwork Monitor GUI client and start monitoring service from “Tools” menu.

3. Save backups to disk different from the one used for IPNetwork Monitor installation

By default, the above mentioned DB Maintenance configuration utilizes the same storage device where monitoring database is located. If you have another disk installed on your computer, the first thing we recommend todo is to create a folder on it, to store IPNetwork monitoring DB backups, and specify it in corresponding field of “Settings > DB Maintenance” section. Disk drives can fail. If you keep DB backups on the same disk where DB itself is located, disk failure will make all of them inaccessible.

4. Backup your backups

When possible, especially after you apply significant changes to monitoring setup, generate a backup file from “Settings > DB Maintenance”, button “Generate DB backup now”, and copy the database backups elsewhere (from their default folder, specified in “Backup to…”

Generate backup now

That will ensure you will have an additional copy of your updated monitoring setup state which can be restored later, in case something goes wrong.

5. Use pinned backups

Normally, older backups generated according to settings in “DB Maintenance”, get deleted (so that you only have specified amount of good backups). In case you need to keep a backup file indefinitely (e.g., if it contains a DB state after important changes), select it from “Available Backups” tab and click “Pin” button. Pinned backups are not deleted automatically; you would need to either “unpin” them (by selecting and clicking “Unpin” button), or delete manually.

6. Check your backups

You do not have a good backup unless you tried to restore it. So, after you have made an important backup, make sure you restore it, to ensure it contains the changes you need:

Restore DB backup

It is recommended to make a backup before you apply significant changes and another one – after you applied them.
Related topics