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

<GrowthIncrement> Element (<FileSpec>)

SQL Server 2000

Specifies the increments by which the database size will increase when additional space is needed.

Structure
<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 SQL Server instance.
Occurrence Optional once per <FileSpec> node.
Updates Cannot be added, deleted, or modified.
Element Relationships
Relationship Elements
Parent Node <FileSpec> 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 database will grow by that percentage of the current database size if it runs out of room and needs to expand.

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