db_recovery_status

(Cluster environments only) 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.

Syntax

db_recovery_status([database_ID | database_name])

Parameters

Examples

Usage

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

  • 1 – indicates the database is in node-failover recovery.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute db_recovery_status.