DROP BACKUP Syntax
Parameters
<backup name>
<backup name>
Name of the backup(s) to delete that are accessible via the data sink given by
data sink name.Use <backup name>* to delete all backups that start with backup name.Use * instead of <backup name> to delete all backups.The
DELETE_ALL_BACKUPS option must be set to true when using *.<data sink name>
<data sink name>
Name of the data sink to use to delete the database
backup files from the remote file store.
WITH OPTIONS
WITH OPTIONS
Optional indicator that a comma-delimited list of deletion option name/value assignments
will follow.Delete options include:
| Option | Description |
|---|---|
DELETE_ALL_BACKUPS | Whether or not to allow multiple backups to be deleted if * is used to specify more than one backup; default (false) is to prevent deleting multiple backups. |
DRY_RUN | Whether or not to execute a dry run of a backup deletion and not actually delete the backup files; default (false) is to delete backups. |
NO_ERROR_IF_NOT_EXISTS | Whether or not to suppress an error if the given backup does not exist; default (false) is to return an error. |
Examples
For example, to delete a backup,schema_backup, via a
data sink, backup_ds, through which the backup files can be accessed:
DROP BACKUP Example
backup_ds data sink that have a
backup name starting with conf:
DROP BACKUP (All Matching Backups at Data Sink) Example
backup_ds data sink:
DROP BACKUP (All Backups at Data Sink) Example