MV_RECOVERY_STATUS

This view includes information about the status of the current recovery process.

This view is also available as an LMV (local view per node) view.

Column Name

Description

DATABASE_NAME

The name of the database being recovered.

DATABASE_ID

The internal ID for the database being recovered.

REPLAY_ETA

The replay % completion and an estimated time to completion.

REPLAY_STATUS

The status of the replay. Possible values: "Recovering snapshot from disk" or "Recovering log files from disk"

REPLAYED_LSN

The Log Sequence Number indicating the position to which changes have been applied to the replica.

STARTUP_COMMITTED_LSN

The Log Sequence Number indicating the position up to which each transaction has been committed.

RECOVERY_TYPE

Possible values: Attach, Restart node, Restore

Last modified: August 30, 2022

Was this article helpful?