0 Replies Latest reply on Dec 17, 2010 4:50 AM by Florian Quadt

    Best practices to backup a Seam application

    Florian Quadt Newbie

      Hello,


      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?


      I am very interested in your ideas..


      Florian