The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.
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
Long, enumerated
Read/write
HRESULT GetFileGrowthType(SQLDMO_GROWTH_TYPE* pRetVal);
HRESULT SetFileGrowthType(SQLDMO_GROWTH_TYPE NewValue);
| 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.