Device type constants define media that is valid as a target for designation as a backup device.
| Constant | Value | Description |
|---|---|---|
| SQLDMODevice_CDROM | 7 | Reserved for future use |
| SQLDMODevice_DiskDump | 2 | Device is a disk file |
| SQLDMODevice_FloppyADump | 3 | Device is a disk file created on removable media in the A drive |
| SQLDMODevice_FloppyBDump | 4 | Device is a disk file created on removable media in the B drive |
| SQLDMODevice_PipeDump | 6 | Device identifies a named pipe |
| SQLDMODevice_TapeDump | 5 | Device is a tape |
| SQLDMODevice_Unknown | 100 | Bad or invalid device type |