FileName Element for FileSpec (ADF)

Specifies the file name and path of a physical data file used by the application database.

Sintassi

<Database>
    <NamedFileGroup>
        ...
        <FileSpec>
            ...
            <FileName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 260 characters in length.

Default value

None.

Occurrence

Required once per FileSpec element.

Updateable

Cannot be added, deleted, or modified when updating the application.

Element Relationships

Relationship Elements

Parent element

FileSpec Element (ADF)

Child elements

None.

Osservazioni

Specify the full path and file name for the named filegroup in the FileName element.

For more information, see os_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.

Esempio

The following example shows how to specify that the application database data file is in the C:\SQLData folder and is named StockPrimary.mdf.

<FileName>C:\SQLData\StockPrimary.mdf</FileName>

Vedere anche

Riferimento

Application Definition File Reference

Altre risorse

Definizione del database dell'applicazione
Aggiornamento di istanze e applicazioni
CREATE DATABASE (Transact-SQL)

Guida in linea e informazioni

Assistenza su SQL Server 2005