Udostępnij za pośrednictwem


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

  • 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)