Delete a Backup Device (SQL Server)
Applies To: SQL Server 2016
This topic describes how to delete a backup device in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.
In This Topic
Requires membership in the diskadmin fixed server role.
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.
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
mybackupdiskbackup device and the physical name
c:\backup\backup1.bak. Execute sp_dropdevice to delete the
mybackupdiskbackup device. The
delfileparameter deletes the physical name.
--Define a backup device and physical name. USE AdventureWorks2012 ; GO EXEC sp_addumpdevice 'disk', 'mybackupdisk', 'c:\backup\backup1.bak' ; GO --Delete the backup device and the physical name. USE AdventureWorks2012 ; GO EXEC sp_dropdevice ' mybackupdisk ', 'delfile' ; GO