Snapshot Backup - sp_delete_backup
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
Deletes all snapshots and the backup file that comprise a snapshot backup set from the specified database. This system stored procedure is the only recommended method for managing snapshot backup sets. For more information, see File-Snapshot Backups for Database Files in Azure.
sys.sp_delete_backup [ @backup_url = ] backup_metadata_file_url ,[ [ @db_name = ] database_name | NULL ]
[ @backup_url = ] backup_meta_file_url
The URL of the backup to be deleted, which deletes all snapshots comprising the specified backup set including the backup file itself.
[ @db_name = ] database_name
The name of the database containing the snapshot to be deleted. When a database name is provided, the system verifies that the backup URL provided is a backup URL for the specified database and uses sp_delete_backup_file_snapshot (Transact-SQL) to delete each snapshot. If no database name is provided, this database check is not performed.
Requires ALTER ANY DATABASE permission or ALTER permission on the specified database.