Data Backup and Restoration

Periodically backing up the database is very essential, as it helps you restore Network Configuration Manager service back during planned maintenance as well as unplanned mishaps. Network Configuration Manager database contains two types of data:
 
Performance data: This is the data gathered by  Network Configuration Manager by periodically polling or querying the resources on a monitored device to determine its performance. This includes resources like CPU, Memory, Response time, Traffic etc.
 
Configuration data: There are quite a few configurations an administrator effects in Network Configuration Manager  for easy management and monitoring. The configurations include user settings, details of discovered devices, custom monitors, threshold settings, notification profiles, etc. Most configuration data is persisted in the database while a few configurations are written in conf files. So when you backup configuration data, you must take care to back up the ones you need.
 

Backup & restoration steps for Network Configuration Manager

Backup:

Following table lists the backup utilities bundled with Network Configuration Manager and their purpose. Make sure you use the one that fits your backup need:

Sl.no                     Utility    Path Database           Purpose
1.

BackupDB.bat (for windows)

BackupDB.sh (for linux)

network-configuration-manager\bin\backup Mysql | MSSQL | PGSQL This utility does a backup of the complete database, viz., performance and configuration data.
2.

BackupDB.bat -mode configdata (for windows)

BackupDB.sh -mode configdata (for linux)

network-configuration-manager\bin\backup Mysql | MSSQL | PGSQL Use this tool if you want to backup only the configuration data with this we backup Conf, Images folder and get the details of Devices, Device Templates, Interfaces, Interface Template, Dashboards & Widgets, Infrastructure Views, Business Views, Credentials, Notification Profiles, Users but not the performance data.

 

Restoration:

To restore the backed up data,
 
Go to <network-configuration-manager Home>/bin/backup directory
Execute RestoreDB.bat (use RestoreDB.sh for linux) with the backup file name as argument. See example below:
C:\<network-configuration-manager Home>\bin\backup>RestoreDB.bat "network-configuration-manager\backup\BackUp_APR3_2009_17_43_38_8100.zip"
To restore the backed up data for MSSQL
 
Go to <network-configuration-manager Home>/bin/backup directory
Restore the data using RestoreDB.bat present under network-configuration-manager/bin/backup directory and restart network-configuration-manager.
For ex : C:\<network-configuration-manager Home>\bin\backup>RestoreDB.bat "c:\network-configuration-manager\backup\BackUp_APR3_2009_17_43_38_8100.zip"
 
While restoring the backup, the tables that are dropped or retained varies according to the backup file restored:

BackupDB.bat/sh: During restoration, all the existing tables are dropped, new tables are created, and the data are restored.

BackupDB.bat/sh -Mode configdata: During restoration, all the existing tables are dropped, new tables are created, and only the configuration data are restored.
 
 

 

Was this article helpful?