LogicalName Element for FileSpec (ICF)

Specifies the logical name of the database file.

Sintassi

<Database>
    <NamedFileGroup>
        ...
        <FileSpec>
            <LogicalName>

Element Characteristics

Characteristic	Description
Data type	string, between 1 and 260 characters in length (see Remarks).
Default value	None.
Occurrence	Required once per FileSpec element.
Updates	Cannot be modified when updating the instance.

Element Relationships

Relationship	Elements
Parent element	FileSpec Element (ICF)
Child elements	None.

Osservazioni

The LogicalName element must be unique in the database and must conform to the rules for identifiers. Even though the LogicalName element accepts up to 260 characters, SQL Server identifiers are limited to 128 characters.

For more information about logical file names, see the logical_file_name description in CREATE DATABASE (Transact-SQL).

If you want to alter the instance database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.

Esempio

This example shows how to specify that the logical name of a database file is StockFG.

<LogicalName>StockFG</LogicalName>

Vedere anche

Riferimento

Application Definition File Reference

Concetti

Instance Configuration File Reference

Altre risorse

Aggiornamento di istanze e applicazioni

Guida in linea e informazioni

Assistenza su SQL Server 2005