Subject | Re: [firebird-support] Help: Firebird 2 database restore |
---|---|
Author | Helen Borrie |
Post date | 2007-03-16T00:28:19Z |
At 10:30 AM 16/03/2007, you wrote:
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
>Just move our database from Firebird 1 to Firebird 2. I try to restoreIt looks as though you are either running Classic or your server isn't running.
>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.
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