FileSpec Element (ADF)
Contains elements that define the application database's data files.
Syntax
<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 |
|
Child elements |
LogicalName Element for FileSpec (ADF) FileName Element for FileSpec (ADF) Size Element for FileSpec (ADF) |
Remarks
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.
Note
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.
Example
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>
See Also
Reference
Application Definition File Reference
Other Resources
Defining the Application Database
Updating Instances and Applications
CREATE DATABASE (Transact-SQL)