Subject RE: [firebird-support] Embedded database backup options
Author Diego Barros
Hi Alan,

Once again, thanks for taking the time to reply.

On Thursday, January 13, 2005, at 10:59PM, Alan McDonald <alan@...> wrote:

>
>> Hi all,
>>
>> I have an application which used an embedded FB database. I was
>> wondering what my best options were to back up the database while
>> the application was running?
>>
>> Do I need to use gbak and call it from the command line?
>>
>> Or is a component a better option?
>
>use the IBOAdmin components - you can backup using the services API

As per my question regarding transactions, I apologize for not being clear on which components I am using. IBOAdmin are third-party components, whereas I am using the Interbase components which come with Delphi 7.

>
>>
>> Can I just disconnect my application from the database and just
>> copy the database file and then reconnect to the database once done?
>
>you could but don't. Use the backup method it's always safer.
>
>>
>> I believe that (I could be wrong) I need to disconnect from the
>> database when using FB as an embedded database, is that correct?
>>
>
>no you stay connected - you can create as many connections to the database
>as you like from the single loaded embedded server.
>Alan

Thanks for the tips.

Cheers,
Diego