SHOW BACKUP

Description

Views the last BACKUP task in a specified database. For more information, see data backup and restoration.

NOTE

Only the information of the last BACKUP task is saved in StarRocks.

SHOW BACKUP [FROM <db_name>]

Parameter	Description
db_name	Name of the database that the BACKUP task belongs to.

Return	Description
JobId	Unique job ID.
SnapshotName	Name of the data snapshot.
DbName	Name of the database that the BACKUP task belongs to.
State	Current state of the BACKUP task: PENDING: Initial state after submitting a job. SNAPSHOTING: Creating snapshot. UPLOAD_SNAPSHOT: Snapshot complete, ready for upload. UPLOADING: Uploading snapshot. SAVE_META: Creating local metadata files. UPLOAD_INFO: Uploading metadata files and information of the BACKUP task. FINISHED: BACKUP task finished. CANCELLED: BACKUP task failed or cancelled.
BackupObjs	Backed up objects.
CreateTime	Task submission time.
SnapshotFinishedTime	Snapshot completion time.
UploadFinishedTime	Snapshot upload completion time.
FinishedTime	Task completion Time.
UnfinishedTasks	Unfinished subtask IDs in the SNAPSHOTING and UPLOADING phases.
Progress	The progress of snapshot uploading tasks.
TaskErrMsg	Error messages.
Status	Status information.
Timeout	Task timeout. Unit: second.

Example 1: Views the last BACKUP task in the database example_db.

SHOW BACKUP FROM example_db;