Hi, > Could you please also clarify the behaviour of BACKUP SQL statement?
The BACKUP statement copies the database file as is and block access from other threads until the file is copied (whether MVCC is enabled or not doesn't matter). Objects are not locked, but the backup is transactionally consistent because the transaction log is also copied (I will document that). > What will happen with new and existing connections if BACKUP statement > will lock the database? Will these connections be rejected or will > they wait until lock will be removed or will they wait for some > timeout? They will wait. 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.
