Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: FireDAC backup OnProgress (Firebird)


This question is answered.


Permlink Replies: 7 - Last Post: Aug 27, 2015 11:02 AM Last Post By: quinn wildman
Eric Buescher

Posts: 15
Registered: 4/30/09
FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 14, 2015 2:20 PM
I am using Delphi XE6 and am implementing the FireDAC backup/restore procedures (TFDFBNBackup/Restore), but the OnProgress event is NOT getting fired. Has this been fixed in XE8, or am I missing something? And if the event ever got fired, how would I determine the progress from the variables passed to the OnProgress method (see below)?
Here is what should get called in my program:
procedure TfrmUtil.FBDBProgress(ASender: TFDPhysDriverService; const AMessage: string);

One more question. What kind of backup gets created? Is this an internal format for FireDAC, or could the backup be restored with Firebird's GBAK routine?

Thanks for any help

Edited by: Eric Buescher on Aug 17, 2015 11:24 AM
quinn wildman

Posts: 856
Registered: 12/2/99
Re: FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 17, 2015 9:44 AM   in response to: Eric Buescher in response to: Eric Buescher
Eric Buescher wrote:
One more question. What kind of backup gets created? Is this an internal format for FireDAC, or could the backup be restored with Firebird's GBAK routine?

It would be a regular FireBird backup, the same that gbak would create.
Eric Buescher

Posts: 15
Registered: 4/30/09
Re: FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 17, 2015 11:25 AM   in response to: quinn wildman in response to: quinn wildman
quinn wildman wrote:
Eric Buescher wrote:
One more question. What kind of backup gets created? Is this an internal format for FireDAC, or could the backup be restored with Firebird's GBAK routine?

It would be a regular FireBird backup, the same that gbak would create.

Quinn, thanks. Any ideas on why the OnProgress event isn't getting fired?
Eric Buescher

Posts: 15
Registered: 4/30/09
Re: FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 27, 2015 9:10 AM   in response to: quinn wildman in response to: quinn wildman
quinn wildman wrote:
Eric Buescher wrote:
One more question. What kind of backup gets created? Is this an internal format for FireDAC, or could the backup be restored with Firebird's GBAK routine?

It would be a regular FireBird backup, the same that gbak would create.

Quinn, it looks like it actually creates an NBackup backup, not GBak.
- Eric
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: FireDAC backup OnProgress (Firebird)
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 18, 2015 1:54 AM   in response to: Eric Buescher in response to: Eric Buescher
Firebird Nbackup service does not support OnProgress event handler.
More precisely isc_service_query API returns nothing.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Eric Buescher

Posts: 15
Registered: 4/30/09
Re: FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 27, 2015 9:20 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Firebird Nbackup service does not support OnProgress event handler.
More precisely isc_service_query API returns nothing.

--
With best regards,
Dmitry Arefiev / FireDAC Architect

Dmitry, how do you backup/restore a firebird db on a mapped network drive? The NBackup documentation says the file needs to be "local" and I can't get it to work with the Delphi FireDAC backup/restore components if the DB is on a mapped drive. I've tried defining the backup filename both as
1) SERVERNAME:c:\dbfiles\database.fdb and
2) Z:\dbfiles\database.fdb where Z: is mapped to SERVERNAME
-Eric
quinn wildman

Posts: 856
Registered: 12/2/99
Re: FireDAC backup OnProgress (Firebird)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 27, 2015 11:02 AM   in response to: Eric Buescher in response to: Eric Buescher
InterBase does not allow databases on a mapped drive, so I would assume
FireBird to be the same.

Eric Buescher wrote:
Dmitry Arefiev wrote:
Firebird Nbackup service does not support OnProgress event handler.
More precisely isc_service_query API returns nothing.

--
With best regards,
Dmitry Arefiev / FireDAC Architect

Dmitry, how do you backup/restore a firebird db on a mapped network drive? The NBackup documentation says the file needs to be "local" and I can't get it to work with the Delphi FireDAC backup/restore components if the DB is on a mapped drive. I've tried defining the backup filename both as
1) SERVERNAME:c:\dbfiles\database.fdb and
2) Z:\dbfiles\database.fdb where Z: is mapped to SERVERNAME
-Eric
Cesar Romero


Posts: 462
Registered: 3/22/00
Re: FireDAC backup OnProgress (Firebird) [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 24, 2015 10:00 AM   in response to: Eric Buescher in response to: Eric Buescher
Eric Buescher wrote:

One more question. What kind of backup gets created? Is this an
internal format for FireDAC, or could the backup be restored with
Firebird's GBAK routine?

NBackup is the Firebird incremental backup tool, it is not the same as
GBAK:

http://www.firebirdsql.org/manual/nbackup.html

<quote>
With nbackup, you can perform two different kinds of tasks:

Making and restoring of both full and incremental backups. An
incremental backup only contains the mutations since some specific
previous backup.

Locking the main database file so you can subsequently back it up
yourself with copying or backup tools of your own choice. In this mode,
nbackup doesn't back up anything; it just creates the conditions under
which you can safely make the backup yourself. There's a provision for
restoring here, too.
</quote>

[]s

cesar Romero

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02