FileName Element for FileSpec (ICF)
Contains the path and file name of the database file.
Синтаксис
<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. |
Updates |
Cannot be added, deleted, or modified when updating the instance. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Замечания
The path portion of the file name must specify a folder accessible by the instance of SQL Server and cannot specify a folder in a compressed file system.
If you need to alter the database after creating the instance, use the SQL Server tools, such as SQL Server Management Studio.
For more information about database file names, see the os_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.
Пример
This example shows how to create the database file in a folder specified by the %BaseDirectoryPath% parameter and has the name Stock.mdf.
<FileName>%BaseDirectoryPath%\Stock.mdf</FileName>
См. также
Справочник
Application Definition File Reference
Основные понятия
Instance Configuration File Reference
Другие ресурсы
CREATE DATABASE (Transact-SQL)
Обновление экземпляров и приложений