SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Notification Services Programming
Instance Configuration File Reference
Instance Configuration File Templates
Application Element (ICF)
ApplicationDefinitionFilePath Element (ICF)
ApplicationName Element (ICF)
Applications Element (ICF)
Argument Element (ICF)
Arguments Element (ICF)
AssemblyName Element (ICF)
BaseDirectoryPath Element (ICF)
Build Element (ICF)
ClassName Element (ICF)
CollationName Element (ICF)
CreationDate Element (ICF)
CreationTime Element (ICF)
Database Element (ICF)
DatabaseName Element (ICF)
DefaultFileGroup Element (ICF)
DeliveryChannel Element (ICF)
DeliveryChannelName Element (ICF)
DeliveryChannels Element (ICF)
EncryptArguments Element (ICF)
FileGroupName Element (ICF)
FileName Element for FileSpec (ICF)
FileName Element for LogFile (ICF)
FileSpec Element (ICF)
GrowthIncrement Element for FileSpec (ICF)
GrowthIncrement Element for LogFile (ICF)
History Element (ICF)
InstanceName Element (ICF)
LastModifiedDate Element (ICF)
LastModifiedTime Element (ICF)
LogFile Element (ICF)
LogicalName Element for FileSpec (ICF)
LogicalName Element for LogFile (ICF)
Major Element (ICF)
MaxSize Element for FileSpec (ICF)
MaxSize Element for LogFile (ICF)
Minor Element (ICF)
Name Element for Application/Parameters/Parameter (ICF)
Name Element for DeliveryChannel/Arguments/Argument (ICF)
Name Element for ParameterDefaults/Parameter (ICF)
NamedFileGroup Element (ICF)
NotificationServicesInstance Element (ICF)
Parameter Element for Application/Parameters (ICF)
Parameter Element for ParameterDefaults (ICF)
ParameterDefaults Element (ICF)
Parameters Element (ICF)
Protocol Element (ICF)
ProtocolName Element for DeliveryChannel (ICF)
ProtocolName Element for Protocol (ICF)
Protocols Element (ICF)
Revision Element (ICF)
SchemaName Element (ICF)
Size Element for FileSpec (ICF)
Size Element for LogFile (ICF)
SqlServerSystem Element (ICF)
Value Element for Application/Parameters/Parameter (ICF)
Value Element for DeliveryChannel/Arguments/Argument (ICF)
Value Element for ParameterDefaults/Parameter (ICF)
Version Element (ICF)
Expand Minimize
This topic has not yet been rated - Rate this topic

FileName Element for LogFile (ICF)

SQL Server 2005

Specifies the path and file name of the database log file.

Copy 

<Database>
    ...
    <LogFile>
        ...
        <FileName>

Characteristic Description

Data type

string, between 1 and 260 characters in length.

Default value

None.

Occurrence

Required once per LogFile element.

Updates

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

Relationship Elements

Parent element

LogFile Element (ICF)

Child elements

None.

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

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

XML
Copy 
<FileName>%BaseDirectoryPath%\Stock.ldf</FileName>
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.