Thomas, Thanks for pointing that out, I did not realize that SCRIPT allowed that. Your solution will work fine. Thanks again!
On Feb 22, 11:44 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > I would use the "script" statement; it does does support an encrypted > target:http://h2database.com/html/grammar.html#script > > It's true that the "backup" statement doesn't encrypt the output file > directly; in theory you could use the "encrypting file system" > implementation, but this implementation is not complete yet. > > Regards, > Thomas > > On Mon, Feb 20, 2012 at 8:21 PM, Adam McMahon > <[email protected]<javascript:;>> > wrote: > > > > > > > > > Hi H2 Group, > > > I have an H2 database that I use the built in AES file encryption. I > > would like to find a good backup solution in which the backup is also > > encrypted using the same file password > > > I could copy the database file, but the database will always be > > running, so simply copying the file may not be a good solution. And, > > if I understand the sql SCRIPT and BACKUP commands correctly they will > > not encrypt the output file. Any ideas? > > > Thanks, > > > -Adam > > > -- > > You received this message because you are subscribed to the Google Groups > > "H2 Database" group.> To post to this group, send email to > [email protected]<javascript:;> > . > > To unsubscribe from this group, send email to > > [email protected] <javascript:;>.> For more options, > visit this group at > > http://groups.google.com/group/h2-database?hl=en. > > > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
