FileSpec Element (ADF)

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

Синтаксис

<Database>
    <NamedFileGroup>
        ...
        <FileSpec>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Required once or more per NamedFileGroup element.

Updates

Cannot be added, deleted, or modified.

Element Relationships

Relationship Elements

Parent element

NamedFileGroup Element (ADF)

Child elements

LogicalName Element for FileSpec (ADF)

FileName Element for FileSpec (ADF)

Size Element for FileSpec (ADF)

MaxSize Element for FileSpec (ADF)

GrowthIncrement Element for FileSpec (ADF)

Замечания

The FileSpec element contains information about a data file that resides on the filegroup specified in the FileGroupName element. You can specify one or more FileSpec elements in a NamedFileGroup element.

ms145317.note(ru-ru,SQL.90).gifПримечание.
If you do not define optional child elements, exclude the child elements from the ADF.

If you need to alter the database after creating the instance of Notification Services, use the Microsoft SQL Server tools, such as SQL Server Management Studio.

For more information about specifying database properties, see the <filespec> section of the CREATE DATABASE (Transact-SQL) topic.

Пример

The following example shows a populated FileSpec node. It specifies information about the StockPrimary data file.

<FileSpec>
    <LogicalName>StockPrimary</LogicalName>
    <FileName>C:\SQLData\StockPrimary.mdf</FileName>
    <Size>2GB</Size>
    <MaxSize>5GB</MaxSize>
    <GrowthIncrement>500MB</GrowthIncrement>
</FileSpec>

См. также

Справочник

Application Definition File Reference

Другие ресурсы

Определение базы данных приложений
Обновление экземпляров и приложений
CREATE DATABASE (Transact-SQL)

Справка и поддержка

Получение помощи по SQL Server 2005