SQL Server/T-SQL Tutorial/System Functions/sp dropdevice
EXEC sp_dropdevice @logicalname = "NWCopyBK_1"
57> EXEC sp_dropdevice @logicalname = "NWCopyBK_1"
58> GO
Msg 15012, Level 16, State 1, Server J\SQLEXPRESS, Procedure sp_dropdevice, Line 37
The device "NWCopyBK_1" does not exist. Use sys.backup_devices to show available devices.
1>