Hi


I can enable and disable database backup mode using:
ALTER DATABASE BEGIN BACKUP
and
ALTER DATABASE END BACKUP

This works though a usual Jaybird SQL connection.
But is there a way to query the database if it is in backup mode or not?

My problem is that I need to be sure that the database is in backup mode to copy the database file but executing the first statement above will result in an sql exception if the database already is in backup mode. So I cannot tell if the exception is about a generic sql error (maybe the connection failed) or if the exception is about the database already being in backup mode.
So I would like to check the state just after executing that statement (and ignoring sql exception).
But how can I check that?


Regards,
Steffen





[Non-text portions of this message have been removed]