GrowthIncrement Element for LogFile (ADF)
Specifies the increments by which the log file size will increase when additional space is needed.
Syntaxe
<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. |
Notes
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.
Exemple
The following example shows how to specify a growth increment of 10 percent.
<GrowthIncrement>10%</GrowthIncrement>
Voir aussi
Référence
Application Definition File Reference
Autres ressources
Définition de la base de données d'application
CREATE DATABASE (Transact-SQL)
Mise à jour des instances et des applications