Size Element for FileSpec (ICF)
Contains the initial size of the database file.
Sintassi
<Database>
<NamedFileGroup>
<FileGroupName>
<FileSpec>
...
<Size>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string. |
Default value |
Default file size for the SQL Server instance, which is typically 1 MB. |
Occurrence |
Optional once per FileGroupName element. |
Updates |
Cannot be added, deleted, or modified when updating the instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Osservazioni
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.
The minimum size is 512 KB. The default size is 1 MB. The size specified for the Primary file must be at least as large as the Primary file of the model database.
For more information, see the size parameter in the CREATE DATABASE (Transact-SQL) topic.
If you want to alter the database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.
Esempio
This example shows how to define the initial size of a database file as 10 MB.
<Size>10MB</Size>
Vedere anche
Riferimento
Application Definition File Reference
Concetti
Instance Configuration File Reference
Altre risorse
Definizione del database dell'istanza
Aggiornamento di istanze e applicazioni