title

sys.backup_devices (Transact-SQL)

description

sys.backup_devices (Transact-SQL)

author

rwestMSFT

ms.author

randolphwest

ms.date

03/14/2017

ms.service

sql

ms.subservice

system-objects

ms.topic

reference

f1_keywords

backup_devices_TSQL

backup_devices

sys.backup_devices

sys.backup_devices_TSQL

helpviewer_keywords

backup devices [SQL Server], viewing information

sys.backup_devices catalog view

dev_langs

TSQL

sys.backup_devices (Transact-SQL)

[!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.

Permissions