Subject RE: [firebird-support] Backup size bigger than restore size
Author Graeme Bruton
Hi Alan

The fbk is bigger than the fdb I have just restored to. The database records
and logs voice calls from a telephone, and certain calls going back further
than a certain date are not playimg back.

Graeme


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Alan McDonald
Sent: Monday, February 06, 2006 4:03 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Backup size bigger than restore size


> Hi all.
>
> 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

file sizes are not the best indicator here.
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




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links










--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 2/4/2006