GrowthIncrement Element for FileSpec (ICF)
Specifies the amount of space added to the database file each time new space is needed.
Syntax
<Database>
<NamedFileGroup>
...
<FileSpec>
...
<GrowthIncrement>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string (see Remarks). |
Default value |
Default growth increment for the SQL Server instance, typically 10 percent. |
Occurrence |
Optional once per FileSpec element. |
Updates |
Cannot be added, deleted, or modified when updating the instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
Specify a whole number. The value can be specified in megabytes (MB), kilobytes (KB), gigabytes (GB), terabytes (TB), or as a percentage (%). If a number is specified without an MB, KB, or % suffix, the default is MB. When % is specified, the growth increment size is the specified percentage of the size of the file at the time the increment occurs.
The minimum growth value is 64 KB. The size specified is rounded to the nearest 64 KB. A value of 0 indicates no growth.
For more information, see the growth_increment parameter in the CREATE DATABASE (Transact-SQL) topic.
If you want to alter the database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.
Example
This example shows how to specify a growth increment of 20 percent. The database file grows by 20 percent each time the database runs out of space until the file reaches the maximum size specified by the MaxSize element.
<GrowthIncrement>20%</GrowthIncrement>
See Also
Reference
Application Definition File Reference
Concepts
Instance Configuration File Reference
Other Resources
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications