DefaultFileGroup Element (ADF)
Specifies one of the NamedFileGroup entries to be used as the default filegroup when creating Microsoft SQL Server objects for this application.
Syntax
<Application>
...
<Database>
...
<DefaultFileGroup>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 0 and 128 characters in length. |
Default value |
The default filegroup of the SQL Server instance being used. |
Occurrence |
Optional once per Database element. |
Updates |
Cannot be added, deleted, or modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
For more information, see the DEFAULT option in the CREATE DATABASE (Transact-SQL) topic.
Example
The following example shows a DefaultFileGroup element naming the Secondary filegroup (previously defined in a FileGroupName element) as the default filegroup for the application.
<DefaultFileGroup>Secondary</DefaultFileGroup>
See Also
Reference
Application Definition File Reference
Other Resources
Defining the Application Database
Understanding Files and Filegroups
CREATE DATABASE (Transact-SQL)
Updating Instances and Applications