EXEC sp_dropdevice @logicalname = 'NWCopyBK_1' : sp_dropdevice « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_dropdevice
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>








25.33.sp_dropdevice
25.33.1.EXEC sp_dropdevice @logicalname = 'NWCopyBK_1'