Skip to content

sys-backup-devices-transact-sql.md

Latest commit

 

History

History
51 lines (40 loc) · 2.69 KB

sys-backup-devices-transact-sql.md

File metadata and controls

51 lines (40 loc) · 2.69 KB
title sys.backup_devices (Transact-SQL)
description sys.backup_devices contains a row for each backup-device registered by using sp_addumpdevice or created in SQL Server Management Studio.
author rwestMSFT
ms.author randolphwest
ms.date 02/05/2026
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]

Returns 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. 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

[!INCLUDE ssCatViewPerm] For more information, see Metadata Visibility Configuration.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER SECURITY STATE permission on the server.

Related content