Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Specifies the increments by which the log file size will increase when additional space is needed.
Syntax
<Database>
...
<LogFile>
...
<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 LogFile element. |
Updateable |
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 log file size at the time the increment occurs. To specify a percentage, use a 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 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