Share via


FileSpec Element (ICF)

Contains elements that describe database file properties.

Sintassi

<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)

Osservazioni

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.

Esempio

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>

Vedere anche

Riferimento

Application Definition File Reference

Concetti

Instance Configuration File Reference

Altre risorse

CREATE DATABASE (Transact-SQL)
Aggiornamento di istanze e applicazioni

Guida in linea e informazioni

Assistenza su SQL Server 2005