Skip to end of metadata
Go to start of metadata

How To - Restore the Server Backup Manager H2 Database from backup

In certain scenarios it is possible to damage the Server Backup Manager internal database, resulting in a Backup Manager that fails to start. Causes for H2 database damage include (but are not limited to) disk or file system corruption, memory exhaustion during key transactions, or allowing the system to run out of disk space.  

This article will guide you through restoring the H2 database from a backup copy.  

Before performing this task, it is recommended that the Server Backup Manager be placed into into Maintenance Mode, to reduce the chance of data corruption.
Once all running and queued tasks have completed, you may safely stop the Backup Manager service.

Solution


By default, the Server Backup Manager takes an automatic nightly backup of the internal H2 database. The H2 database stores internal data for users, groups, task history and other information.
Without the internal H2 database the manager will not function. The H2 database directory along with the backups are stored in the data directory of the installation path. From the Linux command prompt the commands below can used to view and restore the damaged H2 database. 

The command below shows the live h2 directory along with the two available backups.  

# ls -l /usr/sbin/r1soft/data/ drwx------  2 root root   4096 Jan 5  18:00 h2  drwx------  2 root root   4096 Jan 2  02:00 h2-backup-current  drwx------  2 root root   4096 Jan 1  02:00 h2-backup-old  ---------- h2 = Current (active) database h2-backup-current = The most recent system backup h2-backup-old = The oldest system backup

Rename and replace the h2 directory to restore a backup copy of the H2 database: 
1. Change directories to the R1Soft data folder:
# cd /usr/sbin/r1soft/data 

2. Make a backup of the original h2 directory:
# mv /usr/sbin/r1soft/data/h2 h2.backup 

3. Choose a backup and copy it as the h2 folder :
# cp -rv h2-backup-current h2 

4. Verify the new h2 is in place:
# ls -l /usr/sbin/r1soft/data 

5. Restart the SBM service:
systemctl restart sbm-server 
Or 
# /etc/init.d/cdp-server start. 

The Server Backup Manager should now start as normal with the backup h2 database in place. 

After performing these steps, some fields like Policy/Protected Machine status(Success/Failure), Task History, Report Previews will be reset. This is expected behavior as this information is not included in the nightly system backup.

Related Articles


Page: How To - Restore the Server Backup Manager H2 Database from backup (Knowledge Base) Labels: h2, internal, database
Page: How To - Restore the Server Backup Manager H2 Database from backup (Knowledge Base) Labels: h2, internal, database
Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup
Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore
Page: Database Disk Image Malformed (Knowledge Base) Labels: database, disk, image, malformed, disksafe, hardware, faults
Page: How To - Restore the Server Backup Manager H2 Database from backup (Knowledge Base) Labels: h2, internal, database
Labels:
h2 h2 Delete
internal internal Delete
database database Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.