Subject Re: [ib-support] Server-side backups and restores
Author Helen Borrie
At 11:15 AM 29/04/2003 +1000, you wrote:
>Hi all,
>
>I have read on the Borland website that server-side backup and restores are
>a new feature in Interbase V6. I am currently running 6.0.1.6 and using the
>following command: 'gbak -service superman:service_mgr c:\databases\test.gdb
>c:\temp\test.gbk' (where superman is the server, c:\databases is the
>location and c:\temp is where I want a local backup made)
>
>This fails with the message 'ERROR: cannot open backup file
>c:\temp\test.gbk'. I believe this is because it is trying to backup to the
>server machine, which doesn't have that directory.... Am I doing something
>wrong, or is this functionality broken?

No, you are using it with the wrong expectations. The purpose of the
-se[rvice] switch is to let you access the server from a remote station,
run the gbak that is in the server's bin directory and create a backup file
that is *local to the server*.

>I thought I saw a post somewhere that suggested it was broken...

Not as far as I can tell.

>I would like to backup a database from a different computer to the local
>machine. Is it possible to do this with the current version of Interbase?
>(or Firebird...)

Yes - but not using the -se switch.

Here's what I do to create a local backup (into my g: drive) of a database
that is on server 'duck':

..> cd c:\Progra~1\Firebird\bin
..> gbak -b duck:\data\myDb.fdb g:\db_backups\myDb.fbk user sysdba
-password masterkey

heLen