are there any best practices how to backup the data of a Seam application which is based on two H2-databases (first DB for application data, second DB for jBPM data)? I found the Script function of H2 which can be called as a SQL statement or via Java API. I guess the fact that we need to backup two databases which have to be in perfect sync is not trivial.
Should the application do the backup itself (e.g. using a Quartz scheduler) or do you prefer running a backup script at OS level (e.g. as a CRON job)?
What about shutting down the application during backup, is this necessary?