sp_delete_backup (Transact-SQL)
Applies to: SQL Server 2016 (13.x) and later versions
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.
Transact-SQL syntax conventions
Syntax
sys.sp_delete_backup
[ @backup_url = ] N'backup_metadata_file_url'
, [ [ @db_name = ] N'database_name' | NULL ]
Arguments
[ @backup_url = ] N'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 = ] N'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.
Permissions
Requires ALTER ANY DATABASE permission or ALTER permission on the specified database.
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho