Subject | Re: [firebird-support] Re: FireBird Services Manager, backup/restore and isc_service_query/start |
---|---|
Author | Milan Babuskov |
Post date | 2005-05-24T09:07:27Z |
benedicte_asselin wrote:
Before the app. starts the backup it should update the table, and set backup
running to 'YES' and commit. When backup is complete, clear the value. Of
course, you should check if it is already there before you start the backup.
This approach has one problem, a client process could die, or lose connection,
so you're left with 'YES' value. You could also add a timestamp to the table,
and clear the values that are "too old to be true". You can also provide a
"Force backup" option to users if neccessary.
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
> I have used the "isc_service_query" to wait for the end of theYou can make a simple table with column BACKUP_RUNNING and a single row.
> backup/restore, but I can't find any way to know if other
> backup/restore services are currently running.
Before the app. starts the backup it should update the table, and set backup
running to 'YES' and commit. When backup is complete, clear the value. Of
course, you should check if it is already there before you start the backup.
This approach has one problem, a client process could die, or lose connection,
so you're left with 'YES' value. You could also add a timestamp to the table,
and clear the values that are "too old to be true". You can also provide a
"Force backup" option to users if neccessary.
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org