FileSpec Element (ICF)
Contains elements that describe database file properties.
Syntax
<Database>
<NamedFileGroup>
...
<FileSpec>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Required once or more per NamedFileGroup element. |
Updates |
Cannot be added, deleted, or modified when updating the instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
LogicalName Element for FileSpec (ICF) FileName Element for FileSpec (ICF) Size Element for FileSpec (ICF) |
Remarks
If you need to alter the database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.
For more information about specifying database properties, see the <filespec> section of the CREATE DATABASE (Transact-SQL) topic.
Example
This example shows a complete FileSpec element.
<FileSpec>
<LogicalName>Stock</LogicalName>
<FileName>C:\DataFiles\Stock.mdf</FileName>
<Size>20MB</Size>
<MaxSize>40MB</MaxSize>
<GrowthIncrement>20%</GrowthIncrement>
</FileSpec>
See Also
Reference
Application Definition File Reference
Concepts
Instance Configuration File Reference
Other Resources
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications