sys-backup-devices-transact-sql.md

title	sys.backup_devices (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	backup_devices_TSQL backup_devices sys.backup_devices sys.backup_devices_TSQL
dev_langs	TSQL
helpviewer_keywords	backup devices [SQL Server], viewing information sys.backup_devices catalog view
ms.assetid	457edaa4-aca1-4bd3-bf8d-734490b80fcd
caps.latest.revision	32
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.backup_devices (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Contains a row for each backup-device registered by using sp_addumpdevice or created in [!INCLUDEssManStudioFull].

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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

[!INCLUDEssCatViewPerm] 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