Subject RE: [firebird-support] unavailable database
Author RB Smissaert
Finally got the restore running now with:



"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -c -se
localhost:service_mgr I:\Firebird\s6.fbk localhost:I:\Firebird\s6.fdb 500000
localhost:I:\Firebird\s6A.fdb 500000 localhost:I:\Firebird\s6B.fdb -p 4096
-v -user xxx -password yyy



Thanks again for setting me on the right track.



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: 15 January 2008 23:07
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] unavailable database



At 09:16 AM 16/01/2008, you wrote:
>Windows XP Pro
>
>Have downloaded the Windows FB 1.5 installer and installed as Classic.
>
>I can see the Firebird server is running in Services and I can stop and
>start it.
>
>I have a problem though with running gbak, which I did like this:
>
> gbak -c -p 4096 -v -user xxx -password yyy I:\Firebird\s6.fbk
>I:\Firebird\s6.fdb 500000 I:\Firebird\s6A.fdb 500000 I:\Firebird\s6B.fdb
>
> I is a normal (non-mapped) external HD
>
>It fails with this:
>
>gbak: opened file I:\Firebird\s6.fbk
>
>gbak: transportable backup -- data in XDR format
>
>gbak: backup file is compressed
>
>gbak: ERROR: unavailable database
>
>gbak: ERROR: failed to create database I:\Firebird\s6.fdb
>
>gbak: Exiting before completion due to errors
>
> Have tried un-installing and re-installing, but no success.
>
> Any ideas what I am doing wrong here?

Yep. You need to read the Fb 1.5 release notes and/or Quick Start Guide,
where you will discover that you can't use the IPServer "local" connection
protocol to connect to databases under Classic. You must use a remote
protocol and invoke the service manager to perform your backup.

You can use the local loopback server ("localhost") if you are using a
native command shell; if you are running your command shell as a remote
desktop client, you will need to use the node name or static IP address of
the server.

Here's an example (with switches and arguments broken out on separate lines
for clarity):

gbak -c -se localhost:service_mgr
I:\Firebird\s6.fbk
I:\Firebird\s6.fdb 500000 I:\Firebird\s6A.fdb 500000 I:\Firebird\s6B.fdb
-p 4096
-v
-user xxx -password yyy

As a matter of curiosity, why are you restoring to multiple files on an XP
system? is it because disk I: is a fat32 partition?

./heLen





[Non-text portions of this message have been removed]