DROP BACKUP SET¶

Deletes a backup set.

See also:: CREATE BACKUP SET, ALTER BACKUP SET, SHOW BACKUP SETS

Syntax¶

DROP BACKUP SET <name>

Copy

Parameters¶

name

Specifies the identifier for the backup set.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

Access control requirements¶

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Backup set	The role used to modify the backup policy for a backup set must have the OWNERSHIP privilege on the set.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

Important

If the backup policy has a retention lock applied to it, and there are any unexpired backups in the backup set, then you can’t delete the backup set. In that case, you must wait for all the backups in the set to expire. This restriction applies even to privileged roles such as ACCOUNTADMIN, and to Snowflake support. For that reason, be careful when specifying retention lock and a long expiration period in a backup policy.

You also can’t drop a backup set if any of the backups it contains have a legal hold applied.

Examples¶

Delete the backup set t1_backups:

DROP BACKUP SET t1_backups;

Copy