<MaxSize> Element (<FileSpec>)
SQL Server 2000
Specifies the maximum size to which the SQL Server physical database file can grow.
Structure
<Database>
<NamedFileGroup>
...
<FileSpec>
...
<MaxSize>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | string (see Remarks). |
| Default Value | Unrestricted file growth. |
| Occurrence | Optional once per <FileSpec> node. |
| Updates | Cannot be added, deleted, or modified. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <FileSpec> Node |
Remarks
The <MaxSize> value must be a non-negative integer indicating the database 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).