Type Property (BackupDevice)
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.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Syntax
object.Type [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies a device type as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write when using the BackupDevice object to define a backup device. Read-only when the BackupDevice object references an existing backup device.
Prototype (C/C++)
HRESULT GetType(SQLDMO_DEVICE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_DEVICE_TYPE NewValue)
Settings
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 removable media in the A drive. |
SQLDMODevice_FloppyBDump |
4 |
The device is a disk file created on removable media in the B drive. |
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. |