<Size> Element (<LogFile>)
SQL Server 2000
Specifies the initial size of the application log file.
Structure
<Database>
...
<LogFile>
...
<Size>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | string (see Remarks). |
| Default Value | The default initial database size specified for the SQL Server instance; usually 1 megabyte (MB). |
| Occurrence | Optional once per <LogFile> node. |
| Updates | Can be added, deleted, and modified using NSControl Update. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <LogFile> Node |
Remarks
The <Size> value must be a non-negative integer indicating the 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).
Important You can update the <Size> element for documentation purposes, but doing this has no effect on the log file size. If you want to change the size of the log file, use the SQL Server database administration tools to do so. NSControl Update issues a warning if you attempt to update <Database> or any of its subordinate elements, and no changes will be applied to the log file.