Skip to main content

SHOW SNAPSHOT

SHOW SNAPSHOT

Description​

Views data snapshots in a specified repository. For more information, see data backup and restoration.

Syntax​

SHOW SNAPSHOT ON <repo_name>
[WHERE SNAPSHOT = <snapshot_name> [AND TIMESTAMP = <backup_timestamp>]]

Parameters​

Parameter

Description

repo_name

Name of the repository that the snapshot belongs to.

snapshot_nam

Name of the snapshot.

backup_timestamp

Backup timestamp of the snapshot.

Return​

Return

Description

Snapshot

Name of the snapshot.

Timestamp

Backup timestamp of the snapshot.

Status

Displays OK if the snapshot is okay. Displays error message if the snapshot is not okay.

Database

Name of the database that the snapshot belongs to.

Details

JSON-formatted directory and structure of the snapshot.

Example​

Example 1: Views snapshots in repository example_repo.

SHOW SNAPSHOT ON example_repo;

Example 2: Views the snapshot named backup1 in repository example_repo.

SHOW SNAPSHOT ON example_repo
WHERE SNAPSHOT = "backup1";

Example 3: Views the snapshot named backup1 with backup timestamp 2018-05-05-15-34-26 in repository example_repo.

SHOW SNAPSHOT ON example_repo 
WHERE SNAPSHOT = "backup1" AND TIMESTAMP = "2018-05-05-15-34-26";