Size Element for FileSpec (ICF)

Contains the initial size of the database file.

语法

<Database>
    <NamedFileGroup>
        <FileGroupName>
        <FileSpec>
            ...
            <Size>

Element Characteristics

Characteristic Description

Data type

string.

Default value

Default file size for the SQL Server instance, which is typically 1 MB.

Occurrence

Optional once per FileGroupName element.

Updates

Cannot be added, deleted, or 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.

The minimum size is 512 KB. The default size is 1 MB. The size specified for the Primary file must be at least as large as the Primary file of the model database.

For more information, see the 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 define the initial size of a database file as 10 MB.

<Size>10MB</Size>

请参阅

参考

Application Definition File Reference

概念

Instance Configuration File Reference

其他资源

定义实例数据库
更新实例和应用程序

帮助和信息

获取 SQL Server 2005 帮助