Backup and restore of embedded database

Backup and restore of embedded database

InterFormNG2 use as default an embedded database to store processed for input forms, the job logs, email log, printer queues and time-limited stores. The files related to the embedded database cannot be backed up while the InterFormNG2 service is running. One way to do a backup is to stop the InterFormNG2 service, do the backup and then start the InterFormNG2 service again.

It is however possible to do a backup and restore of the objects mentioned above in the embedded database.

Setup of backup

You can setup InterFormNG2 to do backups to an internal folder at regular intervals. That is possible if you sign on to InterFormNG2 as a system administrator. Then you see this in the top ribbon:


As shown above you here select General Settings and then Database Backup, which will scroll to this section of the general settings:

If you want to enable a regular backup you first enable the backup and then you select the Backup interval and the time from which the backups should start.

Backup interval
Here you set how often the backup folder is updated with the backed up data. The possible intervals are:
Every 3 hours
Every 6 hours
Every 8 hours
Every 12 hours
Every 24 hours

Starting from
Here you state at what time of the day, on which the first backup should be done. From then on the objects above will be backed up to the backup folder.

Please note:
  1. The directory where the backups are stored is: {InterFormNG2_Home}\profiles\default\db_backups. On Windows that is as default: C:\ProgramData\InterFormNG2\profiles\default\db_backups
  2. The backup will always overwrite the previous backup.
  3. You can do backups from the {InterFormNG2_Home}\profiles\default\db_backups to your own backup system to e.g. keep older versions.

Restore from a backup

If you want to restore one or more object types from the backup, then you need to sign on as a system administrator and then select Admin followed by Backup as shown below:


Now you can see the latest backup with the timestamp from when it was done:

If you want to restore a backup, which was previously copied from the {InterFormNG2_Home}\profiles\default\db_backups folder, then you should first copy the backup files back into the same folder and the screen above should be updated to show the timestamp of the backup. You might need to refresh the screen with <CTRL>+F5.

As you can see the backup is divided into 4 parts:

Input forms, Job logs (which also includes the email log), the printer queue and the time-limited stores. You can restore each of these objects individually and you do that by pressing this icon on the very right next to the object, that you want to restore:

If you click this icon, then InterFormNG2 first asks you to confirm the restore with this pop-up window:

Here you can click Cancel to not do the restore or Revert to go ahead with the restore.




    • Related Articles

    • Backup and replication

      The following describes the content of the different folders in the INTERFORMNG2_HOME folder and the recommendations for backup and replication of each folder. Note that all “database” folders are typically not used when InterFormNG2 is configured to ...

    • Restore a spooled file

      With InterFormNG2 you restore a spooled file in two manners: You can download a loaded spooled file from the InterFormNG2 library, and upload it into the library (same procedure as an XML file) of another InterFormNG2 installation e.g. on a windows ...

    • To database

      This component writes the current workflow payload to a blob column in a database table. You have to specify the name of the database that the output should be saved to. The use of this is primarily intended for workflows that are initiated by the ...

    • From database

      A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...

    • Database configuration

      The section below describes the database configuration for the From database workflow input, which is very seldomly used. For most you should consider the alternative: From database with custom SQL. To use the database input component, database ...