On Thu, Apr 25, 2013 at 11:53 PM, Robert martin <rob@...> wrote:

>
> > ... a desire to
> > maintain
> > db_key stability or a misunderstanding of garbage collection.
> >
>
> Hi
>
> Actually neither. We have a process where the system does an backup and
> then restores back. The process actually renames the source DB file,
> does the backup and then restores the backup with the initial file
> name. We know that users are logged off because the application doing
> the process is the server part of a client/server system.
>
> We have recently discovered this process sometimes fails because the
> file is in use. My suspicion is that it is in use by the sweep process
> (which I apparently been incorrectly referring to as garbage
> collection). Although all applications have disconnected from the
> database, the FDB file cannot be renamed. Stopping the FB service
> allows a rename.
>

OK - the only safe thing to do is to shut down the server. My recollection
is that the Firebird server keeps a database open for some period of time
after the last connection closes to avoid the cost of reconnection in an
environment where connections are short and frequent.

Sorry to be so long in answering - life intervened

Good luck,

Ann


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