Database Backup and Restore
Periodically backing up the database is very essential, as it helps you restore OpUtils' service back during planned maintenance as well as unplanned mishaps.
Backup
- Open command prompt with administrative privileges and go to < OpUtils Home>/bin/backup directory.
- Execute BackupDB.bat (use BackupDB.sh for Linux) from the command prompt as shown:< OpUtils Home>/bin/backup>BackupDB.bat
- Enter the password as per the given instructions (backup passwords will not be stored anywhere, so users must ensure they remember the passwords).
- Provide the password hint (optional).
- The backup process will begin.
- The backup file created will be stored in < OpUtils Home>\backup directory.
- To store in a different destination use the command given here: BackupDB.bat -destination "" (Eg : BackupDB.bat -destination "C:\Backup").
- Please ensure to store the backup file in a different directory and not in OpUtils' home or sub directories. However, you can use /backup directory to store the backup file.
Note: This utility does a backup of the complete database.
Restoration
To restore the backed up data,
- Open command prompt with administrative privileges and go to < OpUtils Home>/bin/backup directory.
- Execute RestoreDB.bat (use RestoreDB.sh for Linux) with the backup file name as argument from the command prompt as shown below:
- < OpUtils Home>/bin/backup>RestoreDB.bat "<backup file name with path>"
(Eg: RestoreDB.bat "C:\backup\Backup_Pgsql_Mar8_125128_123313.zip" )
- Enter the password for the backup zip file.
- The restoration process will begin.
To restore the backed up data for MSSQL
- For MSSQL database, find the files bcp.exe and bcp.rll in MSSQL server and ensure to copy it to OpUtils home folder. If the MSSQL server is installed on a 64-bit OS, and OpUtils is installed on 32-bit server, the bcp.exe and bcp.rll copied from the MSSQL server will not work on the OpUtils machine. You'll need a 32-bit bcp.exe and bcp.rll
- The backup files taken during the upgrade process cannot be restored.