I tested it out and it seems that the backup becomes completely corrupted.
So one should reserve the db exclusively for himself and only then try
the backup.
- rami
On 7.5.2015 21:24, Rami Ojares wrote:
Hi,
Now when I have moved to mvcc+multithreaded and do my backup using
Script tool the database stays responsive.
I think before every object was locked during backup.
But I started wondering about the consistency of the backup.
Consider the following scenario.
- Table T1 that has FK referring to T2.
- Backup has already processed T1
- Delete on T2 happens that with cascade mechanism removes a row from T1
- Backup now processes T2
The backup is now inconsistent because T1 has a row that refers to a
non-existent row in T2.
Is this possible?
Should I still take my database offline when doing a backup?
- 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].
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.
