Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Specifies the file name and path of a physical data file used by the application database.
Syntax
<Database>
<NamedFileGroup>
...
<FileSpec>
...
<FileName>
Element Characteristics
Characteristic | Description |
---|---|
Data type |
string, between 1 and 260 characters in length. |
Default value |
None. |
Occurrence |
Required once per FileSpec element. |
Updateable |
Cannot be added, deleted, or modified when updating the application. |
Element Relationships
Relationship | Elements |
---|---|
Parent element |
|
Child elements |
None. |
Remarks
Specify the full path and file name for the named filegroup in the FileName element.
For more information, see os_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.
Example
The following example shows how to specify that the application database data file is in the C:\SQLData
folder and is named StockPrimary.mdf
.
<FileName>C:\SQLData\StockPrimary.mdf</FileName>
See Also
Reference
Application Definition File Reference
Other Resources
Defining the Application Database
Updating Instances and Applications
CREATE DATABASE (Transact-SQL)