Share via

  • Article

FileGrowth Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The FileGrowth property specifies the growth increment of the operating system file used to store table, index, or log data.

Syntax

object.FileGrowth [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A long integer

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFileGrowth(LPLONG pRetVal);
HRESULT SetFileGrowth(LONG NewValue);

Remarks

The FileGrowth value is evaluated using the FileGrowthType property.

If FileGrowthType is SQLDMOGrowth_MB, the value represents the number of megabytes of disk space to allocate for incremental file growth.

If FileGrowthType is SQLDMOGrowth_Percent, the value represents a percentage and must be in the range from 1 through 100. Microsoft SQL Server never increments a file in units smaller than one megabyte, regardless of the result of the percentage of file size calculation.