InstanceDatabaseFileGroup Constructor (InstanceDatabaseOptions, String)
Initializes a new instance of the InstanceDatabaseFileGroup class with the parent InstanceDatabaseOptions object and a name.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public Sub New ( _
instanceDatabaseOptions As InstanceDatabaseOptions, _
name As String _
)
public InstanceDatabaseFileGroup (
InstanceDatabaseOptions instanceDatabaseOptions,
string name
)
public:
InstanceDatabaseFileGroup (
InstanceDatabaseOptions^ instanceDatabaseOptions,
String^ name
)
public InstanceDatabaseFileGroup (
InstanceDatabaseOptions instanceDatabaseOptions,
String name
)
public function InstanceDatabaseFileGroup (
instanceDatabaseOptions : InstanceDatabaseOptions,
name : String
)
Parameters
- instanceDatabaseOptions
The parent InstanceDatabaseOptions for the filegroup. This parameter sets the Parent property.
name
A String, between 1 and 128 characters in length, that specifies the name of the filegroup.You cannot change the name. To alter an instance database after creating the instance, use the Microsoft SQL Server tools, such as SQL Server Management Studio.
Remarks
At least one filegroup must use the name PRIMARY.
If you need to alter the database after creating the application, use the Microsoft SQL Server tools, such as SQL Server Management Studio.
Example
The following examples show how to define a filegroup for an instance database:
InstanceDatabaseFileGroup idb_fg =
new InstanceDatabaseFileGroup(idb, "PRIMARY");
idb.InstanceDatabaseFileGroups.Add(idb_fg);
Dim idb_fg As InstanceDatabaseFileGroup = _
New InstanceDatabaseFileGroup(idb, "PRIMARY")
idb.InstanceDatabaseFileGroups.Add(idb_fg)
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
InstanceDatabaseFileGroup Class
InstanceDatabaseFileGroup Members
Microsoft.SqlServer.Management.Nmo Namespace
Other Resources
Defining the Instance Database
NamedFileGroup Element (ICF)
FileGroupName Element (ICF)
CREATE DATABASE (Transact-SQL)