TransactionLog Properties

TransactionLog Object Properties Methods Lists Collections

Property Description

Application
    Application
    Write: No
The Application object.
CreateDate
    String
    Write: No
The date and time the transaction log was created.
IsLogOnSeparateDevice
    Boolean
    Write: No
Indicates if this transaction log is on a separate database device. If True, the transaction log is on a separate device and the Dump method can be used. If False, the transaction log is not on a separate device and the Dump method cannot be used.
LastDump
    String
    Write: No
The date and time this transaction log was last backed up.
Parent
    Database
    Write: No
The Database object.
Size
    Long
    Write: No
The total size in megabytes of the transaction log.
SpaceAvailable
    Long
    Write: No
The total space in kilobytes available for future log growth.
SpaceAvailableinMB
    Float
    Write: No
The total space in megabytes (accurate to two decimal places) available for future log growth.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.