Subject | nBackup Utility |
---|---|
Author | danny_vdw |
Post date | 2009-07-02T18:37:34Z |
Hi,
I m testing the new incremental backup facility for being used in the near future for production.
Test environment:
* Windows Xp SP3 English version, 2 GB RAM
* AMD 4400+ Dual core 2.2 GHz
* Firebird Classic 2.1.3 RC1 (same situation occurs for 2.1.1, we don't use 2.1.2 of singleton bugcheck error in PSQL), pagebuffers 128 16K buffersize
* I'm using Delphi 7 / FIBPlus in a 3 - tier application, 95% of the reads are being done in a read-only read committed trx (this transactions dies after 2 minutes of idle time); all writes occurs in short normal (concurry write) trxs, the gap OIT and Next trx is never big, at most 1000 in the worst case scenario when a OLAP report is running).
When I issue the following command:
nbackup -B 0 inventory.fdb inventory_1-Mar-2006.nbk
I start a fresh full backup for my database Phoenix.
I get a record in the system table rdb$backup_history:
1 2/07/2009 20:06:02 0 {7E18A0C7-D9EE-4CF3-14AB-FC56BBDE21BF} 0 phoenix.fdb-0-20090702-1956.nbk
While the nBackup utility is busy I m gonna stress a little bit the database. I got following files in my directory:
PHOENIX.FDB 10.900.208 KB
phoenix.fdb-0-20090702-1956.nbk 10.701.312 KB
PHOENIX.FDB.delta 158.488 KB
After 11 minutes the nBackup utility finished his job, but still the PHOENIX.FDB.delta file exists, so what is know happened?
Is the merge failed?
Is the merge succeeded but the file isn't deleted?
A full validate says after this situation:
Validation completed, no errors found
What should I do, remove the PHOENIX.FDB.delta or will it be automatically removed when next nBackup cycle start?
Does any one use nBackup in a heavy duty production environment without having trouble / corruption ?
I know much questions, so thx in advance for the answers
Danny
I m testing the new incremental backup facility for being used in the near future for production.
Test environment:
* Windows Xp SP3 English version, 2 GB RAM
* AMD 4400+ Dual core 2.2 GHz
* Firebird Classic 2.1.3 RC1 (same situation occurs for 2.1.1, we don't use 2.1.2 of singleton bugcheck error in PSQL), pagebuffers 128 16K buffersize
* I'm using Delphi 7 / FIBPlus in a 3 - tier application, 95% of the reads are being done in a read-only read committed trx (this transactions dies after 2 minutes of idle time); all writes occurs in short normal (concurry write) trxs, the gap OIT and Next trx is never big, at most 1000 in the worst case scenario when a OLAP report is running).
When I issue the following command:
nbackup -B 0 inventory.fdb inventory_1-Mar-2006.nbk
I start a fresh full backup for my database Phoenix.
I get a record in the system table rdb$backup_history:
1 2/07/2009 20:06:02 0 {7E18A0C7-D9EE-4CF3-14AB-FC56BBDE21BF} 0 phoenix.fdb-0-20090702-1956.nbk
While the nBackup utility is busy I m gonna stress a little bit the database. I got following files in my directory:
PHOENIX.FDB 10.900.208 KB
phoenix.fdb-0-20090702-1956.nbk 10.701.312 KB
PHOENIX.FDB.delta 158.488 KB
After 11 minutes the nBackup utility finished his job, but still the PHOENIX.FDB.delta file exists, so what is know happened?
Is the merge failed?
Is the merge succeeded but the file isn't deleted?
A full validate says after this situation:
Validation completed, no errors found
What should I do, remove the PHOENIX.FDB.delta or will it be automatically removed when next nBackup cycle start?
Does any one use nBackup in a heavy duty production environment without having trouble / corruption ?
I know much questions, so thx in advance for the answers
Danny