Muokkaa

Jaa


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

Important

Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.

[ @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.