Subject Re: gbak: ERROR:unavailable database
Author Vaughan Wickham
Post date 2018-08-24T06:54:35Z
Hello,

I've managed to work this out. One of the challenges when looking at documentation and examples is working out the correct syntax and the fact that Firebird supports multiple OS can make this a challenge.

I think the fundamental issue was that the filesystem format for the destination was wrong in my original example. But in any event I post the full command here (I have also changed some of the switches)

gbak -c -v -user SYSDBA -password masterkey "C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\App\sg_backup.fbk" "localhost:C:\Program Files\Firebird\Firebird_3_0\db\SG1.fdb"

Regards,
Vaughan

On Fri, Aug 24, 2018 at 1:55 PM, Vaughan Wickham <vw@...> wrote:

Hello,

 

I’m a Firebird newbie.

 

I’m using: Firebird-3.0.3.32900_0_x64 on Windows 10

 

Security Gateway uses a Firebird database, I need to enter a large amount of config info into its database, which isn’t going to be feasible via the SG web portal.

 

So I’m trying to restore a backup of the database to Firebird, so I can update the database “offline” and then restore my updated database to SG.

 

I have a backup of the SG database on the computer.

 

I’m trying to perform the restore to Firebird with the following command:

gbak -r o -v -user SYSDBA -password masterkey "C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\ App\sg_backup.fbk" "localhost:/C:/Program Files/Firebird/Firebird_3_0/ db/SG1.fdb"

 

Here is the output:

C:\Program Files\Firebird\Firebird_3_0> gbak -r o -v -user SYSDBA -password masterkey "C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\ App\sg_backup.fbk" "localhost:/C:/Program Files/Firebird/Firebird_3_0/ db/SG1.fdb"

gbak:opened file C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\ App\sg_backup.fbk

gbak:transportable backup -- data in XDR format

gbak:           backup file is compressed

gbak:backup version is 8

gbak: ERROR:unavailable database

gbak: ERROR:failed to create database localhost:/C:/Program Files/Firebird/Firebird_3_0/ db/SG1.fdb

gbak:Exiting before completion due to errors

 

It’s likely that I have stuffed up somewhere, appreciate suggestions on how to isolate the mistake.

 

Thanks

 

Regards,

Vaughan