Archiving and restoring server data

You can archive and restore server data in the realm and profiling databases.

Archiving server data

Along with the running of the server, the sizes of the result version table (DB: realm) and TaskContext table (DB: profiling) grow larger. JReport Server allows you to archive data to a single backup file. You can then retrieve the data from the backup file at a later date.

To archive the server data:

1. On the JReport Administration page, click Data on the system toolbar and then select Realm DB/Profiling DB from the drop-down menu.

   Note: The Profiling DB option is not shown by default on the drop-down menu. To make it shown, set the server.profiling.enable property to true in the server.properties file in the <install_root>\bin directory.

2. Select a realm from the Select Realm drop-down list.
3. Switch to the Archive tab.
4. Specify a date in the Move to Archive Data Before field, and then type or use the Browse button to specify the file path and name.

   If you don't want to backup the archived server data, leave this field blank. The server data will then be removed from the database.

5. Click Archive. Server data prior to the date specified will be archived and saved to the backup file using the name specified.

Restoring the archived server data

You can restore server data that has been archived from a backup file. You can only restore it using the server user interface.

To restore the archived server data:

1. On the JReport Administration page, click Data on the system toolbar and then select Realm DB/Profiling DB from the drop-down menu.
2. Select a realm from the Select Realm drop-down list.
3. Switch to the Archive tab.
4. Type or use the Browse button to provide the archive file name and location in the Restore from archive field, and then click Restore.