Periodically backing up the database is very essential, as it helps you restore OpManager service back during planned maintenance as well as unplanned mishaps. OpManager database contains two types of data:
Performance data: This is the data gathered by OpManager 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 OpManager for easy management and monitoring. The configurations include user settings, details of discovered devices, custom monitors, threshold settings, notification profiles, etc.
Note: This utility does a backup of the complete database, i.e., performance and configuration data. Only the configuration data will be backed up for Netflow Analyzer and Firewall Analyzer modules.
To backup only the configuration data:
<OpManagerHome>/bin/backup>BackupDB.bat -mode configdata
<OpManagerHome>/bin/backup>RestoreDB.bat "<Backup file name with path>"
(Eg: RestoreDB.bat "C:\backup\Backup_Pgsql_Mar8_125128_123313.zip" )
Note: For MSSQL database, find the files bcp.exe and bcp.rll in MSSQL server and ensure to copy it to OpManager home folder. If the MSSQL server is installed on a 64-bit OS, and OpManager is installed on 32-bit server, the bcp.exe and bcp.rll copied from the MSSQL server will not work on the OpManager machine. You'll need a 32-bit bcp.exe and bcp.rll