Subject Re: [firebird-support] Re: Clear database cache?
Author Ann W. Harrison
Matthew,
>
> Frequent (every 5 minutes) automated backups along with the
> option to restore the data from a backup are a requirement of the
> system - and a non-technical user has to be able to perform that
> restoration.

OK, but as Adam said, anything committed after the backup starts
won't be in the restored version.
>
> When the application does a restore, it does first block the user from
> making any data changes (or doing anything besides watching a progress
> bar, really), closes its connections to the database, does the restore
> of the data file, opens new connections, and then lets the user resume
> work.

If you've closed all connections, then the buffers will be flushed.
Are you using Firebird as a shared server, or embedded, or classic?


Regards,


Ann