Subject Re: [firebird-support] Re: FireBird Services Manager, backup/restore and isc_service_query/start
Author Milan Babuskov
benedicte_asselin wrote:
> I have used the "isc_service_query" to wait for the end of the
> backup/restore, but I can't find any way to know if other
> backup/restore services are currently running.

You can make a simple table with column BACKUP_RUNNING and a single row.

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