Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

sp_dropdevice (Transact-SQL)

Drops a database device or backup device from an instance of the SQL Server 2005 Database Engine, deleting the entry from master.dbo.sysdevices.

Topic link icon Transact-SQL Syntax Conventions

Copy 

          

sp_dropdevice [ @logicalname = ] 'device' 
    [ , [ @delfile = ] 'delfile' ]
[ @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.

0 (success) or 1 (failure)

sp_dropdevice cannot be used inside a transaction.

Requires membership in the diskadmin fixed server role.

The following example drops the tapedump1 tape dump device from the Database Engine.

Copy 
EXEC sp_dropdevice 'tapedump1';
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ