Snapshot Backup - sp_delete_backup_file_snapshot
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
Deletes a specified backup snapshot from the specified database. Use this system stored procedure in conjunction with the sys.fn_db_backup_file_snapshots system function to identify and delete orphaned backup snapshots. For more information, see File-Snapshot Backups for Database Files in Azure.
sys.sp_delete_backup_file_snapshot [ @db_name = ] N’<database_name> , [ @snapshot_url = ] N’<snapshot_url>
[ @db_name = ] database_name
The name of the database containing the snapshot to be deleted, provided as a Unicode string.
[ @snapshot_url = ] snapshot_url
The URL of the snapshot to be deleted, provided as a Unicode string.
Requires ALTER ANY DATABASE permission.