On 2021/11/11 12:08 pm, Silvio wrote:
Is there any risk in using the BACKUP command with databases being in (heavy) use? Any increased chance of database corruption? Will it dramatically slow down database access?
In theory, using the BACKUP command on a live MVStore database is possible, what it does is temporarily prevent re-using blocks for the duration of the backup.
So as long as your backup happens fairly quickly, or your database has a fairly light write-load, you should be fine. However, I stress that I don't know that anyone has tested this particularly well. Regards, Noel. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/13f9d727-4f87-7547-a1cb-06f7aa2b56b1%40gmail.com.
