We are using H2 in embedded mode, and have an unusual requirement to
copy snapshots of an open DB file periodically. Is the following
procedure safe (won't lose/corrupt data in the master or snapshot DB
file)?

1) SET EXCLUSIVE 1
2) CHECKPOINT SYNC
3) Copy DB file
4) SET EXCLUSIVE 0
5) Continue using database

This would seem to be much faster than shutting down, copying and
opening the db.

-- 
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.

Reply via email to