다음을 통해 공유


Database Element (ADF)

Contains elements that define the application database.

구문

<Application>
    ...
    <Database>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Optional once per Application element.

Updates

Cannot be added or deleted when updating the application

Element Relationships

Relationship Elements

Parent element

Application Element (ADF)

Child elements

DatabaseName Element (ADF)

SchemaName Element (ADF)

NamedFileGroup Element (ADF)

LogFile Element (ADF)

DefaultFileGroup Element (ADF)

CollationName Element (ADF)

주의

If the Database element and its child elements are not specified, Microsoft SQL Server Notification Services creates an application database using the default settings for the instance of SQL Server.

The following example shows how to specify database settings in an ADF for an application that has two named filegroups, Primary and Secondary, and a log file named StockLog. It uses the Secondary filegroup as its default filegroup, and uses the SQL_Latin1_General_Cp437_BIN collation.

<Database>
    <NamedFileGroup>
        <FileGroupName>Primary</FileGroupName>
        <FileSpec>
            <LogicalName>StockPrimary</LogicalName>
            <FileName>C:\SQLData\StockPrimary.mdf</FileName>
            <Size>2GB</Size>
            <MaxSize>5GB</MaxSize>
            <GrowthIncrement>500MB</GrowthIncrement>
        </FileSpec>
    </NamedFileGroup>
    <NamedFileGroup>
        <FileGroupName>Secondary</FileGroupName>
        <FileSpec>
            <LogicalName>StockSecondary1</LogicalName>
            <FileName>D:\Data\StockSecondary1.ndf</FileName>
            <Size>1000MB</Size>
            <MaxSize>5000MB</MaxSize>
            <GrowthIncrement>25%</GrowthIncrement>
        </FileSpec>
        <FileSpec>
            <LogicalName>StockSecondary2</LogicalName>
            <FileName>D:\Data\StockSecondary2.ndf</FileName>
        </FileSpec>
    </NamedFileGroup>
    <LogFile>
        <LogicalName>StockLog</LogicalName>
        <FileName>E:\Logs\StockLog.ldf</FileName>
    </LogFile>
    <DefaultFileGroup>Secondary</DefaultFileGroup>
    <CollationName>SQL_Latin1_General_Cp437_BIN</CollationName>
</Database>

참고 항목

관련 자료

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

도움말 및 정보

SQL Server 2005 지원 받기