다음을 통해 공유


MaxSize Element for LogFile (ICF)

Specifies the maximum size to which the log file can grow.

구문

<Database>
    ... 
    <LogFile>
        ...
        <MaxSize>

Element Characteristics

Characteristic Description

Data type

string (see Remarks).

Default value

Unrestricted file growth.

Occurrence

Optional once per LogFile element.

Updates

Cannot be modified when updating the instance.

Element Relationships

Relationship Elements

Parent element

LogFile Element (ICF)

Child elements

None.

주의

You can use the kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB) suffix. The default is MB. Specify a whole number; do not include a decimal.

If MaxSize is not specified, the file grows until the disk is full.

Set the maximum log file size to at least 10 MB. Notification Services uses additional log space when you create and update the instance.

For more information, see the max_size 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 maximum log file size of 6 MB.

<MaxSize>6MB</MaxSize>

참고 항목

참조

Application Definition File Reference

개념

Instance Configuration File Reference

관련 자료

인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기