Re: RES: [firebird-support] When I need to do a full backup/restore?

2011-11-22 Thread Alexey Kovyazin
Hello, Also check transaction count limit (2^32-1) in your databases. If Next transaction is close to it, make backup/restore. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) There are no problems (like corruption) if the server was power down during backup? Since backup is an regular

Re: RES: [firebird-support] When I need to do a full backup/restore?

2011-11-21 Thread Mark Rotteveel
On Mon, 21 Nov 2011 08:27:09 -0200, Fabiano fabianoas...@gmail.com wrote: When I restore the backup at a different location how I validate the restored backup? With gfix? Successfully restoring the backup should be sufficient validation in itself. There is a “formula” to indentify that a

Re: RES: [firebird-support] When I need to do a full backup/restore?

2011-11-21 Thread Elmar Haneke
There are no problems (like corruption) if the server was power down during backup? Since backup is an regular read-operation id should not cause corruption when an power-fail does happen while backup. The backup file itself is junk in case of an power-fail. When I restore the backup at a