Skip to main content
Verifies one or more backups accessible via the given data source, checking that each backup’s metadata can be read and that the files its snapshots depend on are present in the remote file store. By default, only the most recent snapshot of each backup is verified.
VERIFY BACKUP Syntax

​
Parameters

<backup name>

Name of the backup(s) to verify that are accessible via the data source given by <data source name>.Use "<backup name>*" (double-quoted) to verify all backups that start with backup name.Use * instead of <backup name> to verify all backups.

<data source name>

Name of the data source to use to access the database backup files in the remote file store.

​
Options

backup_id

ID of the snapshot to verify; the IDs of a backup’s snapshots are listed by DESCRIBE BACKUP.Use -1 to verify all of the backup’s snapshots.If not specified, only the most recent snapshot of each backup is verified.

​
Response

The response to VERIFY BACKUP is a 4-column result set, with one row per backup verified:

​
Examples

To verify the most recent snapshot of the schema_backup backup accessible via the restore_ds data source:
VERIFY BACKUP Example
To verify every snapshot of all backups whose name starts with conf that are accessible via the restore_ds data source:
VERIFY BACKUP (All Snapshots of Backups with Prefix) Example
To verify the most recent snapshot of all backups that are accessible via the restore_ds data source:
VERIFY BACKUP (All Backups at Data Source) Example