Database Backup


Generally, we recommend backing up your data on a daily basis.  To back up all Jedox databases, you must save all folders of the directory <install_path>\olap\data. To do this in Jedox Web, right-click on the database in Modeler and select Download database… For details on download options, see Downloading a Database.

To back up the Jedox In-Memory DB manually on your local machine:

  1. Stop the server.
  2. Copy the databases to another data carrier.
  3. Restart the server.

Automatic Asynchronous Autosave

Jedox 2019.2 automatically saves databases in intervals controlled by the server itself. Automatic asynchronous autosave does not back up your data; rather it saves a “snapshot” of the database until the next autosave replaces that snapshot.

A few highlights of the autosave functionality:

  • Autosave is nonblocking, i.e., users can read and write to the server while save is running.
  • It is fully controlled by the server to prevent big journals from being created to enable fast server restart and minimize problems during journal processing.

Note: the previous autosave function, set in palo.ini, is  obsolete in 2019.2.

The default autosave interval is 5 minutes after the last completed autosave. These intervals can be changed in the configuration file palo.ini with the parameter autosave-interval x, where x is the interval (in minutes) in which automatic asynchronous autosave runs.

Autosave for Legacy Versions

For users still running older versions of Jedox (2019.1 and earlier), autosave can be configured with the autosave parameter in palo.ini. For example, you can obtain a daily automatic data storage at 2:00 am with the following entry in the palo.ini:

autosave T 02:00

Note: the autosave parameter is obsolete in the current version of Jedox (2019.2).