SHOW SNAPSHOT

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";