sys.backup_devices (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains a row for each backup-device registered by using sp_addumpdevice or created in SQL Server Management Studio.

|Applies to: SQL Server ( SQL Server 2008 through current version).|

Column name Data type Description
name sysname Name of the backup device. Is unique in the set.
type tinyint Type of backup device:

2 = Disk

3 = Diskette (obsolete)

5 = Tape

6 = Pipe (obsolete)

7 = Virtual device (for optional use by third-party backup vendors)

Typically, only disk (2) and tape (5) are used.
type_desc nvarchar(60) Description of backup device type:


DISKETTE (obsolete)


PIPE (obsolete)

VIRTUAL_DEVICE (for optional use by third party backup vendors)

Typically, only DISK and TAPE are used.
physical_name nvarchar(260) Physical file name or path of the backup device.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)
BACKUP (Transact-SQL)
Backup Devices (SQL Server)
sp_addumpdevice (Transact-SQL)
Databases and Files Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ