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.


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

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
© 2015 Microsoft