Subject Re: [firebird-support] Firebird database structure question
Author Sam Hunt
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.
>
>
>
just do periodic backups. using gbak, you can back up a database while
it's being used, but don't try restoring one while it's being used, or
you'll corrupt it.
Sam H.