hi, >> 2) BACKUP TOOL can't be used to on-line backup ; even if file systems >> support creating snapshots. >> > Right. The problem is that I have no idea what is the Java API to > actually create such a snapshot. If you know, please tell me. >
I don't think that this is truly necesary , just a clear state of most secure backup form even if it's off-line. Backup is critical for any database, so clear understanding of what's the most reliable backup form and needed conditions is a central point to implement an adequate backup policy. . > ----------------new backup documentation -------------------------- > > The BACKUP SQL statement and the Backup tool both create a zip file > with all database files. However, the contents of this file are not > human readable. > > Unlike than the SCRIPT statement, the BACKUP statement does not lock > the database objects when using the multi-threaded mode, and therefore > does not block other users. The resulting backup is transactionally > consistent: > > BACKUP TO 'backup.zip' > > The Backup tool (org.h2.tools.Backup) can not be used to create a > online backup; the database must not be in use while running this > program. > > Creating a backup by copying the database files while the database is > running is not supported, except if the file systems support creating > snapshots. The problem is that it can't be guaranteed that the data is > > copied in the right order. In my humble opinion, I think that should be documented the OnLIne and OffLine backups as separated procedures - brief, clear and right to the point.. Establishing the preferred way in each case , their required condicions and precautions. The first paragraph of Backup section should be : "Preferred and reliable backup method is ..." And the last paragraph is a technical detail better for another section. ** Anyway your new text far better than the actual. regards, Dario -- 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.
