Share via


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.

Applies To:

BackupDevice Object