MaxSize Element for FileSpec (ADF)
Specifies the maximum size to which the data 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 added, deleted, or modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
주의
The MaxSize value must either be the string UNLIMITED or a nonnegative integer indicating the maximum data file 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).
If you specify UNLIMITED or do not specify a value, the file can grow until the disk is full or until the file is 2 TB.
For more information, see the max_size parameter in the CREATE DATABASE(Transact-SQL) topic.
예
The following example shows how to specify that the database file can grow to 5 GB.
<MaxSize>5GB</MaxSize>
참고 항목
참조
Application Definition File Reference
관련 자료
응용 프로그램 데이터베이스 정의
CREATE DATABASE(Transact-SQL)
인스턴스 및 응용 프로그램 업데이트