Freigeben über


FileName Element for FileSpec (ICF)

Contains the path and file name of the database file.

Syntax

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

Updates

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

Element Relationships

Relationship Elements

Parent element

FileSpec Element (ICF)

Child elements

None.

Hinweise

The path portion of the file name must specify a folder accessible by the instance of SQL Server and cannot specify a folder in a compressed file system.

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 database file names, see the os_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.

Beispiel

This example shows how to create the database file in a folder specified by the %BaseDirectoryPath% parameter and has the name Stock.mdf.

<FileName>%BaseDirectoryPath%\Stock.mdf</FileName>

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