Database Element (ICF)

  • Artikel

Contains elements that configure the instance database.

Syntax

<NotificationServicesInstance>
    ...
    <Database>

Element Characteristics

Characteristic Description

Data type

None

Default value

None

Occurrence

Optional once per NotificationServicesInstance element

Updates

Cannot be added or deleted after creating the instance

Element Relationships

Relationship Elements

Parent element

NotificationServicesInstance Element (ICF)

Child elements

DatabaseName Element (ICF)

SchemaName Element (ICF)

NamedFileGroup Element (ICF)

LogFile Element (ICF)

DefaultFileGroup Element (ICF)

CollationName Element (ICF)

Hinweise

If the instance configuration file (ICF) does not contain a Database element, Notification Services uses the model database as a template when creating an instance database.

The specifications for each application database are contained in each application definition file (ADF).

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

Beispiel

This example shows a complete Database element. The %BaseDirectoryPath% value can be passed in from the command line or can be specified in the ParameterDefaults element of the configuration file.

<Database>
    <DatabaseName>StockInstance</DatabaseName>
    <SchemaName>Stock</SchemaName>
    <NamedFileGroup>
        <FileGroupName>Primary</FileGroupName>
        <FileSpec>
            <LogicalName>PrimaryFG</LogicalName>
            <FileName>%BaseDirectoryPath%\Primary.mdf</FileName>
            <Size>10MB</Size>
            <MaxSize>20MB</MaxSize>
            <GrowthIncrement>20%</GrowthIncrement>
        </FileSpec>
    </NamedFileGroup>
    <NamedFileGroup>
        <FileGroupName>Stock</FileGroupName>
        <FileSpec>
            <LogicalName>StockFG</LogicalName>
            <FileName>%BaseDirectoryPath%\Stock.mdf</FileName>
            <Size>20MB</Size>
            <MaxSize>40MB</MaxSize>
            <GrowthIncrement>20%</GrowthIncrement>
        </FileSpec>
    </NamedFileGroup>
    <LogFile>
        <LogicalName>StockLog</LogicalName>
        <FileName>%BaseDirectoryPath%\Stock.ldf</FileName>
        <Size>5MB</Size>
        <MaxSize>10MB</MaxSize>
        <GrowthIncrement>20%</GrowthIncrement>
    </LogFile>
    <DefaultFileGroup>Stock</DefaultFileGroup>
    <CollationName>SQL_Latin1_General_CP1251_CI_AS</CollationName>
</Database>

Siehe auch

Verweis

Application Definition File Reference

Konzepte

Instance Configuration File Reference

Andere Ressourcen

model-Datenbank
ALTER DATABASE (Transact-SQL)

Hilfe und Informationen

Informationsquellen für SQL Server 2005