Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Specifies the maximum size to which the database file can grow.
Syntax
<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. |
Remarks
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.
Example
This example shows how to specify a maximum database file size of 20 MB:
<MaxSize>20MB</MaxSize>
See Also
Reference
Application Definition File Reference
Concepts
Instance Configuration File Reference
Other Resources
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications