Subject NBACKUP and system failures
Author Steffen Heil
Hi

We want to use nbackup with -L and -N to do filesystem copies (rsync
actually) of our databases.
Now, we will use this quite extensively (that is, about every 1-5 minutes).
And we are currently using firebird 2.0.4.

Therefor I have some questions:
- Is this kind of nbackup usage stable enough?
- Do we have to take any precautions about
- concurrently running gbak backups?
- power failures?
- Anything else?

Especially, what happens if the power goes down while the database is
locked?

- Will the database be consistent after reboots (forced writes is on!)?
- Will the database still be locked?
- Can the locked state be detected?
- What happens if nbackup -L is called while the database is already locked?
- Where does firebird store the information in the meantime?
- Can (where) that storage be configured?
- Is the reintegration process (as nbackup -N) itself safe w.r.t. power
failures and such?

Best regards,
Steffen



[Non-text portions of this message have been removed]