MV_BACKUP_STATUS

This view stores information about the status of ongoing backups.

Column

Description

ORIGIN_NODE_ID

The unique id of the origin node.

DATABASE_NAME

Name of the database being backed up.

TARGET

The local or network filesystem being targeted for the backup.

ROWSTORE_PROGRESS

Progress backing up rowstore represented as a number between 0 and 100.

COLUMNSTORE_PROGRESS

Progress backing up columnstore represented as a number between 0 and 100.

STATUS

Where the backup is currently.

STEP_EST_SEC_REMAIN

The estimated remaining time in seconds for the current step.

Note: information_schema.MV_BACKUP_STATUS is populated only when the BACKUP DATABASE command is run to create a database backup.

Last modified: August 29, 2022

Was this article helpful?