Drops a database device or backup device from an instance of the SQL Server 2005 Database Engine, deleting the entry from master.dbo.sysdevices.
- [ @logicalname = ] 'device'
Is the logical name of the database device or backup device as listed in master.dbo.sysdevices.name. device is sysname, with no default.
- [ @delfile = ] 'delfile'
Specifies whether the physical backup device file should be deleted. delfile is varchar(7). If specified as DELFILE, the physical backup device disk file is deleted.
The following example drops the
tapedump1 tape dump device from the Database Engine.
EXEC sp_dropdevice 'tapedump1';