Delete a Backup Device (SQL Server)
Applies to: SQL Server
This topic describes how to delete a backup device in SQL Server by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To delete a backup device, using:
Before You Begin
Security
Permissions
Requires membership in the diskadmin fixed server role.
Using SQL Server Management Studio
To delete a backup device
After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Server Objects, and then expand Backup Devices.
Right-click the device you want, and then click Delete.
In the Delete Object dialog box, verify that the correct device name appears in the Object Name column.
Click OK.
Using Transact-SQL
To delete a backup device
Connect to the Database Engine.
From the Standard bar, click New Query.
Copy and paste the following example into the query. This example shows how to use sp_dropdevice to delete a backup device. Execute the first example to create the
mybackupdisk
backup device and the physical namec:\backup\backup1.bak
. Execute sp_dropdevice to delete themybackupdisk
backup device. Thedelfile
parameter deletes the physical name.
--Define a backup device and physical name.
USE AdventureWorks2022;
GO
EXEC sp_addumpdevice 'disk', 'mybackupdisk', 'c:\backup\backup1.bak' ;
GO
--Delete the backup device and the physical name.
USE AdventureWorks2022;
GO
EXEC sp_dropdevice ' mybackupdisk ', 'delfile' ;
GO
See Also
View the Properties and Contents of a Logical Backup Device (SQL Server)
sys.backup_devices (Transact-SQL)
BACKUP (Transact-SQL)
Backup Devices (SQL Server)
sp_addumpdevice (Transact-SQL)
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