sys.backup_devices (Transact-SQL)
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: DISK DISKETTE (obsolete) TAPE 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. |
Permissions
In SQL Server 2005 and later versions, 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.