Export (0) Print
Expand All
Expand Minimize

<Size> Element (<FileSpec>)

SQL Server 2000

Specifies the initial size of the application database.

Structure
<Database>
   <NamedFileGroup>
      ...
      <FileSpec>
         ...
         <Size

Element Characteristics
Characteristic Description
Data Type string (see Remarks).
Default Value The default initial database size specified for the SQL Server instance; usually 1 megabyte (MB).
Occurrence Optional once per <FileSpec> node.
Updates Can be added, deleted, and modified using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <FileSpec> Node
Remarks

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

Important  You can update the <Size> element for documentation purposes, but doing this has no effect on the application database size. If you want to change the size of the application database, use the SQL Server database administration tools to do so. NSControl Update issues a warning if you attempt to update <Database> or any of its subordinate elements, and no changes will be applied to the database.

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