Backing up the H2 database - 7.3

Talend Installation Guide

Version
7.3
Language
English
Operating system
Linux
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30

The configuration parameters of the H2 database backup are already set by default so that the backup occurs on an daily basis.

To change this configuration, edit the configuration file: <ApplicationPath>/WEB-INF/classes/configuration.properties

The cron-based backup of the embedded database triggers everyday at 3.45 am all year round. The syntax reads as follows "Seconds Minutes Hours Day-of-month Month Day-of-week Year". For example:

  • 0 45 3 ? * * * (default setting - trigger every day at 3.45 am)

  • 0 45 5 ? * MON-FRI (every Monday, Tuesday, Wednesday, Thursday, and Friday at 5.45 am)

More examples are available onhttp://www.quartz-scheduler.org/documentation/quartz-2.3.0/tutorials/tutorial-lesson-06.html .

Other automatic backups are performed at startup and shutdown of the application server:

database.embedded.backup.doBackupAtStartup=true
database.embedded.backup.doBackupAtShutdown=true

The backup files are stored at the following location, up to the 30 latest backups: <ApplicationPath>/WEB-INF/database/backups