sp_delete_backup_file_snapshot (Transact-SQL)
Applies to: SQL Server 2016 (13.x) and later versions
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.
Transact-SQL syntax conventions
Syntax
sys.sp_delete_backup_file_snapshot
[ @db_name = ] N'database_name'
, [ @snapshot_url = ] N'<snapshot_url>'
Arguments
[ @db_name = ] N'database_name'
The name of the database containing the snapshot to be deleted, provided as a Unicode string.
[ @snapshot_url = ] N'snapshot_url'
The URL of the snapshot to be deleted, provided as a Unicode string.
Permissions
Requires ALTER ANY DATABASE permission.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for