Subject Backup in a client PC
Author Gustavo
Hello:

I use FireBird 2.0, Delphi 5 and IBX.

I have an application which uses many FireBird databases (.FDB files). The databases are in a server PC. This application has an option to make backup and an option to make restore. When a user choses the backup option, he selects which databases he want to backup, and the location to place the backup (the .FBK files). I am using TIBBackupService (and TIBRestoreService for restore) and if the user is in a client PC and he wants to save the backup in a folder in his local drive, he gets an error. As far as I know this is because TIBBackupService can only make backup in drives which are in the same PC as the FireBird server.

Then I tried using gbak. With gbak I can make a backup from a .FDB file which is in the server PC and save it in another PC. So I can call gbak using ShellExecute and it works right. The only thing that is not so good is the following. As some backups take some minutes to finish, when I use TIBBackupService, I can use

while (not EOF) do
MessageDlg(GetNextLine,...);

and show the user a message with these "lines" so he can know the backup option is doing something. But using gbak I can´t do this. I can use -v and even -y <filename.txt> but I didn´t find a way to "get" this verbose to show the user the backup progress.

So my questions are:

1. Is there a way to use TIBBackupService and make a backup in a folder of a drive which is not in the server PC?

2. Is there a way, using gbak, to "get" the verbose into my Delphi application to show the user the backup progress?

And another question.

3. Is there a way to open a database (.FDB file) that is in a folder of a drive in a client PC (not in the server)?

Thanks in advance

Gustavo

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