Subject Re: [firebird-support] Help: Firebird 2 database restore
Author Helen Borrie
At 10:30 AM 16/03/2007, you wrote:
>Just move our database from Firebird 1 to Firebird 2. I try to restore
>the firebird 2 database. Got the error message:
>
>
>
>D:\gbak -C -V d:\backup\db\2007\Data15.3.2007.fdk d:\db\2007\Data.fdb
>gbak:opened file d:\backup\db\2007\Data15.3.2007.fdk
>gbak:transportable backup -- data in XDR format
>gbak: backup file is compressed
>gbak: ERROR:unavailable database
>gbak: ERROR:failed to create database d:\db\2007\Data.fdb
>gbak:Exiting before completion due to errors
>
>Anyone know how to restore it. What options it is.

It looks as though you are either running Classic or your server isn't running.

Anyway, why the D:\gbak etc.?

Go to the Firebird 2 root directory and change to the bin directory.

Next, check that there is not already a file named Data.fdb in folder
d:\db\2007. Don't delete it: rename it.

Then, having made sure the server is running, try this:

gbak -se localhost:service_mgr -C -V
d:\backup\db\2007\Data15.3.2007.fdk d:\db\2007\Data.fdb -user SYSDBA
-password whatever

./heLen