Device Type Constants (SQLDMO_DEVICE_TYPE)

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.

Device type constants define media that are valid as targets for designation as backup devices.

Constant	Value	Description
SQLDMODevice_CDROM	7	Reserved for future use.
SQLDMODevice_DiskDump	2	The device is a disk file.
SQLDMODevice_FloppyADump	3	The device is a disk file created on a removable medium in drive A.
SQLDMODevice_FloppyBDump	4	The device is a disk file created on a removable medium in drive B.
SQLDMODevice_PipeDump	6	The device identifies a named pipe.
SQLDMODevice_TapeDump	5	The device is a tape.
SQLDMODevice_Unknown	100	The device type is not valid.