Backup Properties

Backup Object Properties Collections

Property Description

Application
    Application
    Write: No
The Application object.
DiskDevices
    MultiString
    Write: Yes
Delimited list of hard disk device and volume specifiers. Each specifier consists of the full path and file name of the hard disk device, an equal sign, and an optional volume name.
DumpDevices
    MultiString
    Write: Yes
Delimited list of dump device and volume specifiers. Each specifier consists of the dump device name, an equal sign, and an optional volume name.
DumpExpirationDate
    String
    Write: String
The date and time when the disk or tape device expires. Any attempt to overwrite a dump before this date will fail.
DumpInitDeviceBefore
    Boolean
    Write: Yes
Determines if the disk or tape device is initialized before a dump is performed. If True, the dump starts at the beginning of the device, and any existing data on the device is overwritten. If False, the dump is appended to the end of the device. The default is False.
DumpRetainDays
    Long
    Write: Yes
The number of days after a dump has been performed to retain that dump. Any attempt to overwrite a dump before this number of days has elapsed will fail.
FloppyDevices
    MultiString
    Write: Yes
Delimited list of floppy disk device and volume specifiers. Each specifier consists of the full path and file name of the floppy disk device, an equal sign, and an optional volume name.
LoadFileNumber
    Long
    Write: Yes
The file to load from a tape or disk device.
LoadTableBatchPages
    Long
    Write: Yes
The number of data pages to load between transaction commits during the load of a single table. The default is 0.
Parent
    Application
    Write: No
The Application object.
SkipTapeHeader
    Boolean
    Write: Yes
Determines if the ANSI headers are skipped when dumping to or loading from a tape device. If True, ANSI tape headers are skipped. If False, ANSI tape headers are read. The default is False.
TapeDevices
    MultiString
    Write: Yes
Delimited list of tape device and volume specifiers. Each specifier consists of the full path and file name of the tape device, an equal sign, and an optional volume name.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UnloadTapeAfter
    Boolean
    Write: Yes
Determines if a tape is automatically rewound and unloaded when a dump or load completes. If True, the tape is automatically rewound and unloaded. If False, the tape is left alone. The default is False.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.