sp_dropdevice (T-SQL)

Drops a database device or backup device from Microsoft® SQL Server™, deleting the entry from master.dbo.sysdevices.

Syntax

sp_dropdevice [@logicalname =] 'device'
    [, [@delfile =] 'delfile']

Arguments

[@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'

Is whether or not the physical backup device file should be deleted. delfile is varchar(7). If specified as DELFILE, the physical backup device disk file is deleted.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

sp_dropdevice cannot be used inside a transaction.

Permissions

Execute permissions default to the sysadmin fixed server role, and are not transferable.

Examples

This example drops the TAPEDUMP1 tape dump device from SQL Server.

sp_dropdevice 'TAPEDUMP1'

See Also