Subject | Re: [firebird-support] Re: NBACKUP and system failures |
---|---|
Author | Carlos H. Cantu |
Post date | 2011-04-16T13:40:43Z |
Some past versions of Firebird had problems with nBackup. Afaik,
currently versions should not have problems anymore.
Your approach probably is fine, if your DB is small, so doing a full
backup doesn't take too much time.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
F> I had bad times every time i tried to use nbackup to do what you
F> want to do (frequent backups of online databases, specially when
F> there are many active connections).
F> I tried for 3 or 4 times in production databases, with different
F> firebird versions, hardware and OS, and every time i had my
F> databases hardly corrupted after some days, so i don´t think it is a coincidence...
F> Today i don´t use nbackup anymore and don´t plan to use it
F> further, but i solved my backup needs another way.
F> I do a regular backup of my database using gbak, and sync the fbk file with rsync.
F> You will be surprised with the small size of the delta file
F> between two fbk files taken in distinct times, so it is a good
F> candidate to be used with rsync, instead of the main database file.
F> If you decide to use nbackup every 5 minutes and don´t have issues
F> after some time, please let me know, maybe it is more reliable now.
F> Regards,
F> Fabiano
currently versions should not have problems anymore.
Your approach probably is fine, if your DB is small, so doing a full
backup doesn't take too much time.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
F> I had bad times every time i tried to use nbackup to do what you
F> want to do (frequent backups of online databases, specially when
F> there are many active connections).
F> I tried for 3 or 4 times in production databases, with different
F> firebird versions, hardware and OS, and every time i had my
F> databases hardly corrupted after some days, so i don´t think it is a coincidence...
F> Today i don´t use nbackup anymore and don´t plan to use it
F> further, but i solved my backup needs another way.
F> I do a regular backup of my database using gbak, and sync the fbk file with rsync.
F> You will be surprised with the small size of the delta file
F> between two fbk files taken in distinct times, so it is a good
F> candidate to be used with rsync, instead of the main database file.
F> If you decide to use nbackup every 5 minutes and don´t have issues
F> after some time, please let me know, maybe it is more reliable now.
F> Regards,
F> Fabiano