LogFile Element (ADF)

Contains elements that define the application database's log files.

구문

<Database>
    ...
    <LogFile>

Element Characteristics

Characteristic	Description
Data type	None.
Default value	None.
Occurrence	Zero or more times per Database element.
Updates	Cannot be added or deleted when updating the application.

Element Relationships

Relationship	Elements
Parent element	Database Element (ADF)
Child elements	LogicalName Element for LogFile (ADF) FileName Element for LogFile (ADF) Size Element for LogFile (ADF) MaxSize Element for LogFile (ADF) GrowthIncrement Element for LogFile (ADF)

주의

A LogFile element contains information about an application database log file. You can define zero or more log files.

If you omit the LogFile element and its child elements, Microsoft SQL Server 2005 Notification Services uses SQL Server default settings and creates a single log file that is 25 percent of the sum of the all the database's data files' sizes or 512 KB, whichever is larger.

For more information about defining log files, see CREATE DATABASE(Transact-SQL).

예

The following example shows how to configure a log file for a Stock application.

<LogFile>
    <LogicalName>StockLog</LogicalName>
    <FileName>E:\Logs\StockLog.ldf</FileName>
    <Size>750MB</Size>
    <MaxSize>2GB</MaxSize>
    <GrowthIncrement>250MB</GrowthIncrement>
</LogFile>

참고 항목

참조

Application Definition File Reference

관련 자료

응용 프로그램 데이터베이스 정의
CREATE DATABASE(Transact-SQL)
인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기