Uredi

sp_delete_backup_file_snapshot (Transact-SQL)

  • Članak
  • 2 min. za čitanje

Applies to: yesSQL Server 2016 (13.x) and later

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.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sys.sp_delete_backup_file_snapshot  
    [ @db_name = ] N'<database_name>  
    , [ @snapshot_url = ] N'<snapshot_url>

Arguments

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

Permissions

Requires ALTER ANY DATABASE permission.

See Also

sys.fn_db_backup_file_snapshots (Transact-SQL)
sp_delete_backup (Transact-SQL)