Subject RE: [firebird-support] Compressed backup file format, any way to validate?
Author Brenden Walker
> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
>
> At 08:26 AM 6/9/2004, Brenden Walker wrote:
> >I've got a 5gig gbk ... that I attempted to restore. GBAK
> reports that
> >it's compressed, but when I look at the file in a hex editor part of
> >the file in the beginning ...
>
> The first part of a backup is the contents of the system
> tables. That's probably what looks uncompressed. Gbak
> restores the schema first then the data.
>
> >Are there any utilities that can validate proper format of
> an IB or FB
> >backup file?
>
> Unfortunately, the only one is gbak. What errors are you
> getting? What does the output look like when you restore
> with the -v switch?

The last thing output in the log file:

gbak: restoring function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restoring argument for function F_GENERATEFORMATTEDNAME
gbak: restorin

There are no errors reported (that I can see) it appears to be happily
restoring away. GBAK blows up at that point, I'd try to restore in FB but
we have several field names that cause problems for FB (type, timestamp, if
I remember correctly).

This customer is apparantly also having a variety of network problems, so
it's certainly conceivable that the actual GBK file is corrupted in some
way.