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.

附註：
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 協助