GrowthIncrement Element for FileSpec (ADF)

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

Sintaxis

<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 Microsoft SQL Server instance.
Occurrence	Optional once per FileSpec element.
Updates	Cannot be added, deleted, or modified when updating the application.

Element Relationships

Relationship	Elements
Parent element	FileSpec Element (ADF)
Child elements	None.

Notas

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 database size at the time the increment occurs. To specify a percentage, use the percent (%) sign.

For more information, see the growth_increment parameter in the CREATE DATABASE (Transact-SQL) topic.

Ejemplo

The following example shows how to specify a database growth increment of 500 MB.

<GrowthIncrement>500MB</GrowthIncrement>

The following example shows how to specify a growth increment of 10 percent.

<GrowthIncrement>10%</GrowthIncrement>

Vea también

Referencia

Application Definition File Reference

Otros recursos

Definir la base de datos de aplicación
CREATE DATABASE (Transact-SQL)
Actualizar instancias y aplicaciones

Ayuda e información

Obtener ayuda sobre SQL Server 2005