Size Element for LogFile (ADF)

Specifies the initial size of the application log file.

Syntax

<Database>
    ...
    <LogFile>
        ...
        <Size>

Element Characteristics

Characteristic Description

Data type

string (see Remarks).

Default value

The default initial log file size; usually 1 megabyte (MB).

Occurrence

Optional once per LogFile element.

Updates

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

Element Relationships

Relationship Elements

Parent element

LogFile Element (ADF)

Child elements

None.

Remarks

The Size value must be a nonnegative integer indicating the initial log 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).

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

Example

The following example shows a Size element that specifies an initial size of 300 MB for the log file.

<Size>300MB</Size>

See Also

Reference

Application Definition File Reference

Other Resources

Defining the Application Database
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance