I think you have to turn off the space re-using or something like that
while running the backup?
Maybe that should happen automatically as part of the script tool?
On 8/05/2015 7:48 AM, Rami Ojares wrote:
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
