Partager via


Size Element for LogFile (ICF)

Specifies the initial size of the log file.

Syntaxe

<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

LogFile Element (ICF)

Child elements

None.

Notes

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.

Exemple

This example shows how to define the initial size of a log file as 3 MB.

<Size>3MB</Size>

Voir aussi

Référence

Application Definition File Reference

Concepts

Instance Configuration File Reference

Autres ressources

CREATE DATABASE (Transact-SQL)
Définition de la base de données d'instance
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005