Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

<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.

See Also
Defining a <LogFile> Node
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.