Subject | Re: [firebird-support] Re: Embedded / Backup |
---|---|
Author | Nando Dessena |
Post date | 2004-12-08T07:32:49Z |
Hello,
h> I'm using Firebird 1.5 and delphi 7 in my application. the
h> ibbackupservice seem to be no problem. But when I restoring the
h> database using the ibrestoringservice component it has a error message
h> of "cannot open the test.gbk" where test.gbk is my database back-up.
h> Should I close first the db connection before process the restoring
h> the open the connection after I restore the db.
If you are trying to restore a backup over an existing database, to
which you are even connected then you should thank goodness that
Firebird is stopping you with an error from doing such a dangerous
thing. ;-)
Of course you have to disconnect from a database before you can
*overwrite it* from a backup with a restore operation. I'd also add
that I wouldn't restore over the existing database but always under a
different name. When the restore completes you can then rename files
as necessary and reconnect. This is not specific to fbembed, BTW.
Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
h> I'm using Firebird 1.5 and delphi 7 in my application. the
h> ibbackupservice seem to be no problem. But when I restoring the
h> database using the ibrestoringservice component it has a error message
h> of "cannot open the test.gbk" where test.gbk is my database back-up.
h> Should I close first the db connection before process the restoring
h> the open the connection after I restore the db.
If you are trying to restore a backup over an existing database, to
which you are even connected then you should thank goodness that
Firebird is stopping you with an error from doing such a dangerous
thing. ;-)
Of course you have to disconnect from a database before you can
*overwrite it* from a backup with a restore operation. I'd also add
that I wouldn't restore over the existing database but always under a
different name. When the restore completes you can then rename files
as necessary and reconnect. This is not specific to fbembed, BTW.
Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================