Periodically backing up the database is very essential, as it helps you restore NetFlow Analyzer service back during planned maintenance as well as unplanned mishaps. NetFlow Analyzer database contains the following data:
Configuration data: There are quite a few configurations an administrator effects in NetFlow Analyzer or 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.
Following table lists the backup utilities bundled with NetFlow Analyzer and their purpose. Make sure you use the one that fits your backup need:
BackupDB.bat (for windows)
BackupDB.sh (for linux)
|OpManager\bin\backup||MSSQL | PGSQL||This utility does a backup of the configuration.|
To restore the backed up data,
To restore the backed up data for MSSQL
For ex : C:\<OpManager Home>\bin\backup>RestoreDB.bat "c:\OpManager\backup\BackUp_APR3_2009_17_43_38_8100.zip"