共用方式為


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 協助