Delete a Backup Device (SQL Server)
This topic describes how to delete a backup device in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL.
In This Topic
-
Before you begin:
-
To delete a backup device, using:
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.
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 name c:\backup\backup1.bak. Execute sp_dropdevice to delete the mybackupdisk backup device. The delfile parameter 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
