Subject RE: [firebird-support] Can I copy the embedded database file on the fly?
Author Alan McDonald
> Hi,
> Is it safe to make a file copy of the embedded database file ***.fdb
> while the application is still connected to that file? The
> applications is multi-threaded but access to the database is
> synchronized by the use of semaphore and all changes to the database
> via insert/update/delete are commited immediately before releasing the
> semaphore by the accessing thread.
> My application is a daemon application and it nevers shutdown so I
> programmed the application to backup the database file by file copy on
> the fly at midnight upon a configurable number of days has elapsed.
> Thanks for info
> Jeff

why don't you just make your daemon use the services API to make a real
backup? Then there's no questions about it's validity.