다음을 통해 공유


Size Element for FileSpec (ADF)

Specifies the initial size of the application database.

구문

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

Element Characteristics

Characteristic Description

Data type

string (see Remarks).

Default value

The model database size for the primary file; 1 MB for secondary files.

Occurrence

Optional once per FileSpec element.

Updates

Cannot be added, deleted, and modified when updating the application.

Element Relationships

Relationship Elements

Parent element

FileSpec Element (ADF)

Child elements

None.

주의

The Size value must be a nonnegative integer indicating the database size, with an optional suffix to indicate the unit of measure: kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB). If the suffix is not specified, the default unit of measure is megabytes (MB).

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

The following example shows a Size element that specifies an initial size of 1 GB for the database file.

<Size>1GB</Size>

참고 항목

참조

Application Definition File Reference

관련 자료

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

도움말 및 정보

SQL Server 2005 지원 받기