Size Element for LogFile (ICF)
Specifies the initial size of the log file.
구문
<Database>
...
<LogFile>
...
<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 LogFile element. |
Updates |
Cannot be added, deleted, or 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.
The minimum size is 512 KB. The default size is 1 MB.
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 log file as 3 MB.
<Size>3MB</Size>
참고 항목
참조
Application Definition File Reference
개념
Instance Configuration File Reference
관련 자료
CREATE DATABASE(Transact-SQL)
인스턴스 데이터베이스 정의
인스턴스 및 응용 프로그램 업데이트