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 nameData typeDescription
namesysnameName of the backup device. Is unique in the set.
typetinyintType 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_descnvarchar(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_namenvarchar(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.

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

Community Additions