db_recovery_status

Returns the recovery status of the specified database. Returns the recovery status of the current database if you do not include a value for database_ID or database_name.

db_recovery_status([database_ID | database_name])

• database_ID – the id of the database whose recovery status you are requesting.

• database_name – the name of the database whose recovery status you are requesting.

This returns the recovery status of the current database:

select db_recovery_status()

This returns the recovery status of the database with named test:

select db_recovery_status("test")

This returns the recovery status of a database with a database id of 8:

select db_recovery_status(8)

A return value of 0 indicates the database is not in node-failover recovery. A return value of 1 indicates the database is in node-failover recovery.

Any user can execute db_recovery_status.