TIBCBackupService - create backup of server-DB on client?

[ralfiii]

Hello!

Is it possible to create the backup-file (the .fbk-file) of a server-database on the client where the backup is started?
If I specify

Code: Select all

     
     BackupService.Database := 'E:\ServerDb.fdb';
     BackupService.Server:='MyServer';
     BackupService.BackupFile.Clear;
     BackupService.BackupFile.Add('C:\test.fbk');

the backup file shows up on the server-PC and not on the client where I am running the backup-process.
Obviously it must be possible, because I can simply run gbak from a bat-file to do that.
But: is it also possible with IBDac or do I have to run the batch-file?

[ZEuS]

Hello!

TIBCBackupService uses Interbase Service Manager, which runs on the server, so all filenames refer to the server environment and not to local drive. Therefore make sure that 'C:\test.fbk' is correct server path.

[ralfiii]

TIBCBackupService uses Interbase Service Manager, which runs on the server, so all filenames refer to the server environment and not to local drive. Therefore make sure that 'C:\test.fbk' is correct server path.

So does that mean I can NOT create a backup of a server-PC and store the backup file on a client-PC using the IBDac-Components?
I am using firebird 2.5 and if I log in on a client PC and enter

Code: Select all

%FirebirdPath%\gbak.exe -B -USER sysdba -PASSWORD masterkey ServerPcName:E:\Test.fdb C:\Test.fbk

then the resulting backup file is created - exactly as I need it - on the client machine where I run this command.
Naturally I would prefer using IBDac directly.

[ZEuS]

Hello.

gbak.exe is a separate command line tool that does not use Interbase Service Manager unlike the TIBCBackupService.
To create a backup of a server-PC and store the backup file on a client-PC using TIBCBackupService, you can try the following:
- create a shared folder on the client-PC;
- make a link to this folder on the server-PC (just as a mapping network drive in Windows);
- create a backup with TIBCBackupService using this link as a path to the backup file.

[ralfiii]

Sorry but this is no solution at all.
As soon as a customer runs Win7 or with restricted user rights, this is a no-go solution. Or if a customer doesn't have physical access to the server (which is VERY common for database servers).
So I can only use gbak.

gbak.exe is a separate command line tool that does not use Interbase Service Manager unlike the TIBCBackupService.
To create a backup of a server-PC and store the backup file on a client-PC using TIBCBackupService, you can try the following:
- create a shared folder on the client-PC;
- make a link to this folder on the server-PC (just as a mapping network drive in Windows);
- create a backup with TIBCBackupService using this link as a path to the backup file.

[ZEuS]

Yes, you are right. If any other questions come up, please contact us.

[Djura]

But,
on a server i have mapped network drive,
and TIBCBackupService will be on server from app executed, where FB server is,
and i want Backup file on network mapped drive, visible from server, with all rights.

with gbak it works, but with TIBCBackupService no....
pls, help?

[ZEuS]

It's better to use gbak to perform backup of remote database to a local folder, because Firebird violates using network drives for performing backup with Service Manager.