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	NamedFileGroup Element (ICF)
Child elements	LogicalName Element for FileSpec (ICF) FileName Element for FileSpec (ICF) Size Element for FileSpec (ICF) MaxSize Element for FileSpec (ICF) GrowthIncrement Element for FileSpec (ICF)

Hinweise

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.

Beispiel

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>

Siehe auch

Verweis

Application Definition File Reference

Konzepte

Instance Configuration File Reference

Andere Ressourcen

CREATE DATABASE (Transact-SQL)
Aktualisieren von Instanzen und Anwendungen

Hilfe und Informationen

Informationsquellen für SQL Server 2005