> > Is it possible to restore a FDB from a FBK using all gbak default
> options
> > and have the FDB file smaller than thd FBK file (in a database with

many

> > indices and foreign keys)?
>
> There was a thread about such issue few months ago. I believe it was

on

> this list. Someone reported to have the same situation, so I guess it

is

> possible.

Actually it is not.

The FBK is the most compressed natural representation of a database that
can be made -- containing none of the overhead that is required for an
operational database (Indexes data, RDB$Pages table, record and page
headers).

The users are most probably seeing an "artifact" of using Windows
Explorer to view the FDB file size.

Remember: Windows does not update the file information for some
databases until the database is closed.


Sean