sys.sp_dropdevice

Description

Drops a database device or backup device from a SQL Server Database Engine instance, The logical name of the database device or backup device as listed in Specifies whether the physical backup device file should be deleted. , the physical backup device disk file is deleted.

Syntax

master.dbo.sysdevices

Examples

Example 1

sp_dropdevice

Example 2

tapedump1

Example 3

EXECUTE sp_dropdevice
'tapedump1'
;