Contains a row for each backup-device registered by using sp_addumpdevice or created in SQL Server Management Studio.
|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:
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.
Catalog Views (Transact-SQL)
Backup Devices (SQL Server)
Databases and Files Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ