I'll add a bit to Lesters answer. It IS possible to have several
files, but the purpose of it is to limit the size of each file
(normally we're talking about gigabytes in each file) and you cannot
decide what goes into which file. Furthermore, one of the benefits of
Firebird not being dBase is that Firebird is far more robust and that
corruption rarely occurs unless there is some sort of disk problem
(don't read this as 'hooray, I don't need to learn how to use gbak', I
only meant for you to relax and don't spend your nights worrying about
whether the database would still be running tomorrow).

By the way, always use gbak (or dbak) for backups, never just copy the
.fdb file unless you're 103% certain no-one is connected to it.

Set

--- In firebird-support@yahoogroups.com, Lester Caine wrote:
> tablazincata wrote:
>
> > By default a .fdb database file (specific to Firebird) contains
> > several tables, which means that if something happens to the .fdb
> > file that will affect all the tables whithin the .fdb. What can I
> > do, or how can I configure the Firebird server so that the tables
> > to be in distinct files.
>
> Firebird is not dBase ;)
>
> All of the data to manage the tables in a database is held in the
> .fdb file. If you do use more than one file, then the 'systems
> tables' have to be duplicated in each .fdb file, and queries
> between tables are not possible! ( With the current versions of
> Firebird )
>
> The safety is provided by regular backup of the database.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services