Subject | Re: gfix and the SYSDBA user |
---|---|
Author | Petr Jakes |
Post date | 2007-10-24T17:03:51Z |
> Hi,Yes, the gbak utility is OK to make backup of the FB. The problem is
>
>> we are using FB 1.0, 1.5, 2.0 versions on Linux and Windows.
>> All FB clients are connected as SYSDBA.
>>
>> Is it possible to use the gfix utility to shut down the database
>> and make a copy of it (on the OS file level) for the backup? Till
>> now we are stopping the service for the daily backup/restore
>> process but we are thinking about rewriting our maintenance script.
>
> Use gbak to create a backup while your Firebird database is in use.
we are making gbak/restore daily. And the restore of the database is
not possible, while users are connected.
>> I know in the FB2.0 it is possible to use gfix with the "-FULL"Yes, the only way is to force our customers to upgrade to FB 2.0.
>> parameter to make the "Exclusive shutdown". But what about
>> FB < 2.0?
>
> If you don't want to shutdown the server with FB < 2.0,
> then gbak is the only way.
>
> In Firebird 2.x, you can use nbackup to bring the database into
> a state where it can be copied at file system level safely, even
> while there are other users connected.
>
> Check out the nbackup guide here:
> http://www.firebirdsql.org/manual/nbackup.html
Anyway, thanks for your comment.
Petr Jakes
> --
> Best Regards,
> Thomas Steinmaurer