SQL Server/T-SQL Tutorial/System Functions/sp dropdevice
EXEC sp_dropdevice @logicalname = "NWCopyBK_1"
<source lang="sql">
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></source>