Subject | RE: [firebird-support] Backup size bigger than restore size |
---|---|
Author | Alan McDonald |
Post date | 2006-02-06T14:03:25Z |
> Hi all.file sizes are not the best indicator here.
>
> I need to restore a database that was backed up on the 8th December 2005,
> but not necessarily to the current live database. On the Fedora
> Core 3 box,
> I run gbak -c -v /backup/database.fbk
> localhost:/opt/firebird/database.fdb,
> but when I compare file sizes, the restored database is 485MB, and the
> backup from the 8th is 1.4GB, and it looks like not all the data has come
> back. Am I doing something wrong, or what is going on here?
>
> Your assistance would be greatly appreciated.
>
> Graeme
Depending on page size setting, file sizes can be quite different.
There there is the issue of how much garbage there was in the oroginal file.
Do you mean the fbk file is larger? or the old fdb file?
A resotred file will often be smaller than the original.
What tests have you done to conclude that not all the data is back?
Alan