MaxSize Element for FileSpec (ICF)
Specifies the maximum size to which the database 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 modified when updating the instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Notas
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.
If MaxSize is not specified, the file grows until the disk is full.
For more information, see the max_size parameter in the CREATE DATABASE (Transact-SQL) topic.
If you want to alter the instance database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.
Ejemplo
This example shows how to specify a maximum database file size of 20 MB:
<MaxSize>20MB</MaxSize>
Vea también
Referencia
Application Definition File Reference
Conceptos
Instance Configuration File Reference
Otros recursos
CREATE DATABASE (Transact-SQL)
Actualizar instancias y aplicaciones