Subject | NBACKUP and system failures |
---|---|
Author | Steffen Heil |
Post date | 2011-02-16T13:06:02Z |
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]
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]