Subject RE: [firebird-support] Embedded / Backup
Author Alan McDonald
> >Someone has asked this before but noone answered..
> >If you use the embedded server and you want to backup the database under
> >application user control, what do you do?
>
> Gbak makes its own connection to a database. Since a database under
> embedded can take one and only one user connection, it's not possible for
> gbak to connect to the database while your user application is connected.
>
> >I notice that IBExpert can do this but I'm not sure how they do it...
> >What would be the call if you use IBObject components?
>
> You would have to write the application so that it disconnects from the
> database before invoking the Execute method of the
> IBOAdminBackupService. This is probably contrary to the way you usually

???? you mean the IBBackupService? (IBX)
Where is the IBOAdminBackupService component?

> write applications for multi-user use. Mostly, we combine the startup of
> our IBO database apps with the database connection, i.e. we tie the
> creation of the main form to the activation of the db connection. Though
> its' what most of us do most of the time, it's not necessarily
> the best way
> to implement connections if you want to write scalable apps. It doesn't
> make sense for multi-tier, for example. Admin tools like
> IBExpert, et al.,
> don't do it, of course, since they have no way at startup to know what
> database they are going to connect to.

I'm yet to find out what IBExpert is actually doing here since I can backup
a local database but gbak is not present on my PC...


Alan