This document
explains you about creating a database backup and restoring it. Creating
a backup of the database is an essential need for every enterprise.
So
you need to ensure that the significant data is backed up periodically.
Follow the methods mentioned below to backup and restore your database.
OpUtils currently
supports database backup and restore for MSSQL and PostgreSQL(PGSQL) database.
Database backup can be done manually by following the steps mentioned
below:
Note: BCP should be installed on the computer where OpUtils is installed.
If OpUtils and MSSQL Server are installed in the same machine, ensure that BCP is working. You can verify that, by following the
steps mentioned below:
If OpUtils and MSSQL server are installed on different computers, then follow the steps mentioned below:
Follow the steps mentioned below to backup MSSQL database:
Open command prompt and locate OPUTILS_HOME\bin ( Eg. C:\Program Files\ManageEngine\OpUtils\bin )
Execute backupDB.bat
<backup-directory> <backup-filename>
For Example: backupDB.bat C:\Program Files\ManageEngine\OpUtils\ScheduleBackup\
ManualBackUp_5_Aug_2013
Ensure that the data backup is successfully stored in the location <backup-filename>.zip (ManualBackUp_5_Aug_2013.zip)
You have successfully stored the MSSQL database backup.
Follow the steps mentioned below to backup PGSQL database:
Open command prompt and locate OPUTILS_HOME\bin ( Eg. C:\Program Files\ManageEngine\OpUtils\bin )
Execute backupDB.bat/sh
<backup-directory> <backup-filename>
For Example: backupDB.bat C:\Program Files\ManageEngine\OpUtils\ScheduleBackup\
ManualBackUp_5_Aug_2013
Ensure that the data backup is successfully stored in the location <backup-filename>.zip (ManualBackUp_5_Aug_2013.zip).
You have successfully stored the PGSQL database backup.
Follow the steps mentioned below to schedule the database backup:
Go to OpUtils
Click Admin tab
Under Admin from the left pane, click Scheduled Backup
Specify the Backup Directory
Specify the number of backups that need to be maintained
Select the drop down to enable/disable the Backup Scheduler and specify the time interval for the database backup to be performed
Click Save to store the changes.
You have successfully scheduled the database backup.
Follow the steps mentioned below to restore the MSSQL database:
Stop the OpUtils server
Go to the machine where MSSQL database is installed and rename or delete the corrupted database "OpUtilsDB" to "OpUtilsDB_Corrupted"
Create a new database "OpUtilsDB"
Go to machine where OpUtils is installed and navigate to the location OPUTILS_HOME\bin
Execute restoreDB.bat
<backup-zipfile>
For Example: restoreDB.bat C:\Program Files\ManageEngine\OpUtils\ScheduleBackup\ManualBackUp_5_Aug_2013.zip
After the batch execution is complete, Start the OpUtils server
You have successfully restored the MSSQL database backup.
Follow the steps mentioned below to restore the PGSQL database:
Stop the OpUtils server
Execute restoreDB.bat/sh
<backup-zipfile>
For Example: restoreDB.bat C:\Program Files\ManageEngine\OpUtils\ScheduleBackup\ManualBackUp_5_Aug_2013.zip
After the batch execution is complete, Start the OpUtils server
You have successfully restored the PSQL database backup.