HI, > do I understand it right that "backupto" and "script" are two completely > different ways to backup the database ?
Yes. If possible, I would use "script", as this will allow you to open the database in future versions of H2, and possibly in other databases. > Does the file location for the runscript (to restore the script result) has > to be placed on the server or on the client side ? If you use the RUNSCRIPT command, then on the server side. With the RunScript tool, you can do both. > Wich kind of backup is the best and safest way to do ? The BACKUP command might be faster, but the safest is using SCRIPT, as it will also check the internal consistency of the data (it will verify the checksums and parse all data, while BACKUP is just a raw copy of the file data). Regards, Thomas -- 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.
