sys-sysdevices-transact-sql.md

title	sys.sysdevices (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysdevices sysdevices_TSQL sys.sysdevices sys.sysdevices_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sysdevices compatibility view sysdevices system table
ms.assetid	ac5bcaf4-8fb6-4855-8856-d7643f469361
author	rothja
ms.author	jroth

sys.sysdevices (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains one row for each disk backup file, tape backup file, and database file.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
name	sysname	Logical name of the backup file or database file.
size	int	Size of the file in 2-kilobyte (KB) pages.
low	int	Maintained for backward compatibility only.
high	int	Maintained for backward compatibility only.
status	smallint	Bitmap indicating the type of device: 1 = Default disk 2 = Physical disk 4 = Logical disk 8 = Skip header 16 = Backup file 32 = Serial writes 4096 = Read-only
cntrltype	smallint	Controller type: 0 = Non-CD-ROM database file 2 = Disk backup file 3 - 4 = Diskette backup file 5 = Tape backup file 6 = Named-pipe file
phyname	nvarchar(260)	Name of the physical file.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)