Partilhar via

InstanceDatabaseOptions.DefaultFileGroup Property

  • Artigo

Gets or sets the default filegroup for the instance database.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property DefaultFileGroup As String

public string DefaultFileGroup { get; set; }

public:
property String^ DefaultFileGroup {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_DefaultFileGroup ()

/** @property */
public void set_DefaultFileGroup (String value)

public function get DefaultFileGroup () : String

public function set DefaultFileGroup (value : String)

Property Value

A String containing name of the default filegroup.

Remarks

The default filegroup must be the name of one of the InstanceDatabaseFileGroup objects for this instance. Any instance object without a specified filegroup is created in the default filegroup. If you do not specify a default filegroup, the default is PRIMARY.

Example

The following examples show how to set the default filegroup for an instance database:

idb.DefaultFileGroup = "PRIMARY";

idb.DefaultFileGroup = "PRIMARY"

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

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

InstanceDatabaseOptions Class
InstanceDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining the Instance Database
DefaultFileGroup Element (ICF)