versioned_docs/version-1.2/sql-manual/sql-reference/Show-Statements/SHOW-RESTORE.md

---
{
    "title": "SHOW-RESTORE",
    "language": "en"
}
---

## SHOW-RESTORE

### Name

SHOW RESTORE

### Description

This statement is used to view RESTORE tasks

grammar:

```SQL
SHOW RESTORE [FROM DB_NAME]
```

illustrate:
        1. Only the most recent RESTORE task is saved in Doris.
                2. The meaning of each column is as follows:
            JobId: Unique job id
            Label: The name of the backup to restore
            Timestamp: The time version of the backup to restore
            DbName: belongs to the database
            State: current stage
                PENDING: The initial state after submitting the job
                SNAPSHOTING: Executing snapshot
                DOWNLOAD: The snapshot is complete, ready to download the snapshot in the repository
                DOWNLOADING: Snapshot downloading
                COMMIT: Snapshot download is complete, ready to take effect
                COMMITING: in effect
                FINISHED: The job was successful
                CANCELLED: Job failed
            AllowLoad: Whether to allow import when restoring (currently not supported)
            ReplicationNum: Specifies the number of replicas to restore
            RestoreJobs: Tables and partitions to restore
            CreateTime: task submission time
            MetaPreparedTime: Metadata preparation completion time
            SnapshotFinishedTime: Snapshot completion time
            DownloadFinishedTime: Snapshot download completion time
            FinishedTime: Job finish time
            UnfinishedTasks: Displays unfinished subtask ids during SNAPSHOTING, DOWNLOADING and COMMITING stages
            Status: If the job fails, display the failure message
            Timeout: Job timeout, in seconds

### Example

1. View the latest RESTORE task under example_db.

   ```sql
   SHOW RESTORE FROM example_db;
   ```

### Keywords

    SHOW, RESTORE

### Best Practice