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 | Device is a disk file |
| SQLDMODevice_FloppyADump | 3 | Device is a disk file created on removable media in drive A |
| SQLDMODevice_FloppyBDump | 4 | Device is a disk file created on removable media in drive B |
| SQLDMODevice_PipeDump | 6 | Device identifies a named pipe |
| SQLDMODevice_TapeDump | 5 | Device is a tape |
| SQLDMODevice_Unknown | 100 | Bad or invalid device type |