Hi, Sorry for the delay.
> What updates do make it in the backup and which ones do not? Some make it, some don't make it. There is no guarantee when exactly the backup stops. But the backup is transactionally consistent. Regards, Thomas On Fri, May 8, 2015 at 12:45 PM, Rami Ojares <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > > Either this, or use the "backup" SQL statement. With the MVStore storage, >> this should work very well. With the PageStore, it should also work, but I >> didn't test as much. >> > > I tried the BACKUP command and it seems to work. > > Then I made one test. > I started the BACKUP sql command. > While it was running, I inserted one single row into a table. > I restored the backup. > But I could still see the row that was inserted while the backup was > running. > > Documentation says: > "Objects are not locked, but the backup is transactionally consistent > because the transaction log is also copied." > > I don't know how to interpret this. > What updates do make it in the backup and which ones do not? > > > - Rami > > -- > 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
