Compartir a través de


MaxSize Element for FileSpec (ADF)

Specifies the maximum size to which the data file can grow.

Sintaxis

<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 added, deleted, or modified when updating the application.

Element Relationships

Relationship Elements

Parent element

FileSpec Element (ADF)

Child elements

None.

Notas

The MaxSize value must either be the string UNLIMITED or a nonnegative integer indicating the maximum data 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).

If you specify UNLIMITED or do not specify a value, the file can grow until the disk is full or until the file is 2 TB.

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

Ejemplo

The following example shows how to specify that the database file can grow to 5 GB.

<MaxSize>5GB</MaxSize>

Vea también

Referencia

Application Definition File Reference

Otros recursos

Definir la base de datos de aplicación
CREATE DATABASE (Transact-SQL)
Actualizar instancias y aplicaciones

Ayuda e información

Obtener ayuda sobre SQL Server 2005