Export (0) Print
Expand All
Expand Minimize

<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).

See Also
Defining a <NamedFileGroup> Node
Show:
© 2014 Microsoft