File Growth Constants (SQLDMO_GROWTH_TYPE)

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.

File growth constants control evaluation of a file growth increment for operating system files that maintain Microsoft SQL Server database and transaction log data.

Constant

Value

Description

SQLDMOGrowth_Invalid

99

Reserved for future use.

SQLDMOGrowth_MB

0

Default for SQL Server database files. The growth increment is interpreted as a size, in megabytes.

SQLDMOGrowth_Percent

1

Default for the primary data file and SQL Server log files. The growth increment is interpreted as a percentage of the space currently allocated.