共用方式為


GrowthIncrement Element for LogFile (ADF)

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

語法

<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

LogFile Element (ADF)

Child elements

None.

備註

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.

範例

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

<GrowthIncrement>10%</GrowthIncrement>

請參閱

參考

Application Definition File Reference

其他資源

定義應用程式資料庫
CREATE DATABASE (Transact-SQL)
更新執行個體及應用程式

說明及資訊

取得 SQL Server 2005 協助