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 |
|
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)
인스턴스 및 응용 프로그램 업데이트