<GrowthIncrement> Element (<LogFile>)
SQL Server 2000
Specifies the file name and path of a physical log file used by the application database.
Structure
<Database>
...
<LogFile>
...
<GrowthIncrement>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | string (see Remarks). |
| Default Value | Increases by the default database growth increment specified for the SQL Server instance. |
| Occurrence | Optional once per <LogFile> node. |
| Updateable | Cannot be added, deleted, or modified. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <LogFile> Node |
Remarks
The <GrowthIncrement> value must be either the increment size or a percentage. If you choose to indicate the increment size, the value must be a non-negative 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 log file will grow by that percentage of the current log file size if it runs out of room and needs to expand.