GrowthIncrement Element for LogFile (ICF)

Specifies the amount of space that can be added to the log file when the log file is full.

Синтаксис

<Database>
    ...
    <LogFile>
        ...
        <GrowthIncrement>

Element Characteristics

Characteristic Description

Data type

string (see Remarks).

Default value

Default growth increment for the Microsoft SQL Server instance, typically 10 percent.

Occurrence

Optional once per LogFile element.

Updates

Cannot be added, deleted, or modified when updating the instance.

Element Relationships

Relationship Elements

Parent element

LogFile Element (ICF)

Child elements

None.

Замечания

Specify a whole number. The value can be specified in megabytes (MB), kilobytes (KB), gigabytes (GB), terabytes (TB), or as a percentage (%). If a number is specified without an MB, KB, or % suffix, the default is MB. When % is specified, the growth increment size is the specified percentage of the size of the file at the time the increment occurs.

The minimum growth value is 64 KB. The size specified is rounded to the nearest 64 KB. A value of 0 indicates no growth.

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

If you want to alter the database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.

Пример

This example shows how to specify a growth increment of 15 percent. The log file grows by 15 percent each time the log runs out of space, until the file reaches the maximum size specified by the MaxSize element.

<GrowthIncrement>15%</GrowthIncrement>

См. также

Справочник

Application Definition File Reference

Основные понятия

Instance Configuration File Reference

Другие ресурсы

CREATE DATABASE (Transact-SQL)
Обновление экземпляров и приложений

Справка и поддержка

Получение помощи по SQL Server 2005