File Growth Constants (SQLDMO_GROWTH_TYPE)

SQL-DMO

SQL-DMO

File Growth Constants (SQLDMO_GROWTH_TYPE)

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.

See Also

FileGrowth Property

FileGrowthType Property