Page 1 of 1
TIBCBackupService - create backup of server-DB on client?
Posted: Mon 23 Apr 2012 12:19
by 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?
Posted: Mon 23 Apr 2012 13:47
by 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.
Posted: Tue 24 Apr 2012 07:28
by ralfiii
ZEuS wrote: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.
Posted: Wed 25 Apr 2012 12:35
by 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.
Posted: Wed 25 Apr 2012 14:29
by 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.
ZEuS wrote: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.
Posted: Thu 26 Apr 2012 07:05
by ZEuS
Yes, you are right. If any other questions come up, please contact us.
Re: TIBCBackupService - create backup of server-DB on client?
Posted: Thu 19 Nov 2015 16:08
by 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?
Re: TIBCBackupService - create backup of server-DB on client?
Posted: Tue 24 Nov 2015 10:31
by 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.