GrowthIncrement Element for FileSpec (ADF)
Specifies the increments by which the data file size will increase when additional space is needed.
Syntax
<Database>
<NamedFileGroup>
...
<FileSpec>
...
<GrowthIncrement>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string (see Remarks). |
Default value |
Increases by the default database growth increment specified for the Microsoft SQL Server instance. |
Occurrence |
Optional once per FileSpec element. |
Updates |
Cannot be added, deleted, or modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
The GrowthIncrement value must be either the increment size or a percentage. If you specify an increment size, the value must be a nonnegative integer, with an optional suffix to indicate the unit of measure: kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB). If the suffix is not specified, the default unit of measure is megabytes (MB). If you specify a percentage, the growth increment size is the specified percentage of the database size at the time the increment occurs. To specify a percentage, use the percent (%) sign.
For more information, see the growth_increment parameter in the CREATE DATABASE (Transact-SQL) topic.
Example
The following example shows how to specify a database growth increment of 500 MB.
<GrowthIncrement>500MB</GrowthIncrement>
The following example shows how to specify a growth increment of 10 percent.
<GrowthIncrement>10%</GrowthIncrement>
See Also
Reference
Application Definition File Reference
Other Resources
Defining the Application Database
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications