Re: backup encrypted database

2012-02-23 Thread Adam McMahon
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 thomas.tom.muel...@gmail.com wrote: Hi, I would use the script statement; it does does support an encrypted

backup encrypted database

2012-02-22 Thread Thomas Mueller
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

backup encrypted database

2012-02-20 Thread Adam McMahon
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