Online/Hot Backups:
Online backup of the HSQL involves taking backup of database files qppdb.script, qppdb.log and qppdb.properties. To restore HSQL database we need to copy the backed up database files in the database folder (location: QPS Server\Database\hsqldb) and re-start the server.

Offline/Cold Backups:
Following are the two strategies for taking cold backups:

  • Strategy – I

1. Shut down the Server.

2. Back up the following files from the “hsqldb” folder (location: QPS Server\Database\hsqldb)

a. qppdb.script

b. qppdb.properties

c. qppdb.log

    1. Restart the Server.

  • Strategy – II
    1. Shut down the Server.
    2. Start the Server (To ensure that log file is read and qppdb.script file is populated leaving log file empty).
    3. Again shut down the server.
    4. Back up the following files from the “hsqldb” folder (location: QPS Server\Database\hsqldb)
      1. qppdb.script
      2. qppdb.properties
    5. Restart the Server.

In order to ensure that file server is in sync with database, user should also backup the following:

· Asset repository

· Scheduler scripts

· Job Jacket folders

This backup should be done for both Online/Offline backups.