共用方式為


LogicalName Element for LogFile (ICF)

Specifies the logical name of the log file.

語法

<Database>
    ... 
    <LogFile>
        <LogicalName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 260 characters in length (see Remarks).

Default value

None.

Occurrence

Required once per LogFile element.

Updates

Cannot be modified when updating the instance.

Element Relationships

Relationship Elements

Parent element

LogFile Element (ICF)

Child elements

None.

備註

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.

範例

This example shows how to specify that the logical name of a log file is StockLog.

<LogicalName>StockLog</LogicalName>

請參閱

參考

Application Definition File Reference

概念

Instance Configuration File Reference

其他資源

CREATE DATABASE (Transact-SQL)
更新執行個體及應用程式

說明及資訊

取得 SQL Server 2005 協助