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.

Was this article helpful?