OpUtils periodically backup the database file and store it in the file system. The backup interval can be configured as low as every day depending on the importance. In case of database failure or corruption, you can restore the data from the backup files. This article will guide you through the steps to restore a previously backed up OpUtils Database.
Follow the steps below to restore the data from backup. You need to perform these steps from the computer where OpUtils is installed.
Important: The current build number and the backup version should be the same. The name of the backup zip file will begin with the build number of the OpUtils. For example, a backup file 57003_2009_Nov_25_11_46.zip denotes that the backed up database pertains to build number 57003 with the date and time at which the backup has been taken. You can verify the current build number by clicking the About link from the top-right of the OpUtils client.
- Ensure that Oputils is running before you perform the steps. Open the Task Manager and check whether the process fbserver.exe is running.
- The backup files will be stored in <Install_Dir>/ScheduleBackup directory. If this has been changed, take a backup zip from the location where the backup files are stored. Extract the zip to a directory, say Desktop.
- Open a command prompt and change directory to extracted directory (e.g. C:\Documents and Settings\Administrator\Desktop)
- Execute the following command:
<OpUtils_Install_Dir>\ManageEngine\OpUtils\firebird\bin\gbak.exe -c -v -user SYSDBA -password masterkey OpUtilsDB.fbk localhost/33105:<OpUtils_Install_Dir>\ManageEngine\OpUtils\firebird\Restored_OpUtilsDB.fdb
<OpUtils_Install_Dir> denotes the directory where OpUtils is installed. the default being C:\Program Files
- This will restore the database from the backup file. You will see a series of entries printed in the command prompt when the restoration is in progress and comes back to the prompt when completed.
- After the restoration is complete, you will see a new file as Restored_OpUtilsDB.fdb in <OpUtils_Install_Dir>\ManageEngine\OpUtils\firebird directory.
- Stop OpUtils from Start --> Programs --> ManageEngine OpUtils --> Stop OpUtils
- Navigate to the <OpUtils_Install_Dir>\ManageEngine\OpUtils\firebird directory.
- Rename the OpUtilsDB.fdb to OpUtilsDB_old.fdb
- Rename Restored_OpUtilsDB.fdb to OpUtilsDB.fdb
- Start OpUtils and check the data in from the OpUtils client.
- If you are sure that the data has been completely restored, you can safely delete the OpUtilsDB_old.fdb file.
Keywords: disaster recovery, database restore, firebird database, backup database, data restore
Support will be available 24hrs a day and five days a week (Monday through Friday), excluding USA & India public holidays.
Tel : +1-888-720-9500
Speak to us
- Join the OpUtils Community, to get instant answers for your queries, register with our Forum.
- Tweet the latest happenings in OpUtils, follow us at Twitter.