Subject | Can I copy the embedded database file on the fly? |
---|---|
Author | Jeff Lynn |
Post date | 2006-05-25T18:04:15Z |
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
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