MaxSize Element for FileSpec (ICF)

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

구문

<Database>
    <NamedFileGroup>
        ...
        <FileSpec>
            ...
            <MaxSize>

Element Characteristics

Characteristic	Description
Data type	string (see Remarks).
Default value	Unrestricted file growth.
Occurrence	Optional once per FileSpec element.
Updates	Cannot be modified when updating the instance.

Element Relationships

Relationship	Elements
Parent element	FileSpec 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.

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

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

예

This example shows how to specify a maximum database file size of 20 MB:

<MaxSize>20MB</MaxSize>

참고 항목

참조

Application Definition File Reference

개념

Instance Configuration File Reference

관련 자료

CREATE DATABASE(Transact-SQL)
인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기