FileGrowthType Property

SQL-DMO

SQL-DMO

FileGrowthType Property

The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.

Applies To
DBFile Object LogFile Object
Syntax

object.FileGrowthType [= value]

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies application of the FileGrowth property as described in Settings

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFileGrowthType(SQLDMO_GROWTH_TYPE* pRetVal);

HRESULT SetFileGrowthType(SQLDMO_GROWTH_TYPE NewValue);

Settings
Constant Value Description
SQLDMOGrowth_MB 0 Growth increment is interpreted as a size, in megabytes.
SQLDMOGrowth_Percent 1 Default. Growth increment is interpreted as a percentage of the space currently allocated.

Remarks

Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.