The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.
| DBFile Object | LogFile Object |
object.FileGrowthType [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying application of the FileGrowth property as described in 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. |
Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.
Long, enumerated.
Read/write
HRESULT GetFileGrowthType(SQLDMO_GROWTH_TYPE* pRetVal);
HRESULT SetFileGrowthType(SQLDMO_GROWTH_TYPE NewValue);