sp_helpdevice (Transact-SQL)
Reports information about Microsoft® SQL Server™ backup devices.
![]() |
---|
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. We recommend that you use the sys.backup_devices catalog view instead |
Column name |
Data type |
Description |
---|---|---|
device_name |
sysname |
Logical device name. |
physical_name |
nvarchar(260) |
Physical file name. |
description |
nvarchar(255) |
Description of the device. |
status |
int |
A number that corresponds to the status description in the description column. |
cntrltype |
smallint |
Controller type of the device: 2 = Disk device 5 = Tape device |
size |
int |
Device size in 2-KB pages. |