sys.backup_devices (Transact-SQL)
Applies to: 
SQL Server
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) 9 = URL Typically, only disk (2) and URL (9) are used. |
| type_desc | nvarchar(60) | Description of backup device type: DISK DISKETTE (obsolete) TAPE PIPE (obsolete) VIRTUAL_DEVICE (for optional use by third party backup vendors) URL Typically, only DISK and URL are used. |
| physical_name | nvarchar(260) | Physical file name or path of the backup device. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was 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