| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.backup_devices (Transact-SQL) |
sys.backup_devices (Transact-SQL) |
rwestMSFT |
randolphwest |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains a row for each backup-device registered by using sp_addumpdevice or created in [!INCLUDEssManStudioFull].
| 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. |
[!INCLUDEssCatViewPerm] 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