Media type constants are used to direct the behavior of the EnumAvailableMedia method of the SQLServer object.
| Constant | Value | Description |
|---|---|---|
| SQLDMOMedia_All | 15 | List all media |
| SQLDMOMedia_CDROM | 8 | List visible CD-ROM devices |
| SQLDMOMedia_FixedDisk | 2 | List visible fixed disk drive devices |
| SQLDMOMedia_Floppy | 1 | List visible floppy disk drive devices |
| SQLDMOMedia_SharedFixedDisk | 16 | List visible fixed disk drive devices shared on a clustered computer |
| SQLDMOMedia_Tape | 4 | List visible tape devices |