Udostępnij za pośrednictwem

InstanceDatabaseLogFile.Parent Property

  • Artykuł

Gets or sets the InstanceDatabaseOptions object for the instance database.

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

Syntax

'Declaration
Public Property Parent As InstanceDatabaseOptions

public InstanceDatabaseOptions Parent { get; set; }

public:
property InstanceDatabaseOptions^ Parent {
    InstanceDatabaseOptions^ get ();
    void set (InstanceDatabaseOptions^ value);
}

/** @property */
public InstanceDatabaseOptions get_Parent ()

/** @property */
public void set_Parent (InstanceDatabaseOptions value)

public function get Parent () : InstanceDatabaseOptions

public function set Parent (value : InstanceDatabaseOptions)

Property Value

The InstanceDatabaseOptions object for the instance database.

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

Each InstanceDatabaseLogFile has a parent InstanceDatabaseOptions. You typically supply the parent object when you create the InstanceDatabaseLogFile using the InstanceDatabaseLogFile(InstanceDatabaseOptions,String) constructor.

If you set the parent in the constructor, do not set the parent using this property. Setting the parent twice throws an exception.

Example

The following examples show how to set the Parent property when using the default constructor:

// Create log file and set properties.
InstanceDatabaseLogFile idb_log = new InstanceDatabaseLogFile();

// Required properties.
idb_log.Name = "MyInst_LogFile1";
idb_log.Parent = idb;
idb_log.FileName = @"C:\NS\Default\MyInst_LogFile1.ldf";

// Optional properties.
idb_log.InitialSize = "3MB";
idb_log.MaxSize = "10MB";
idb_log.GrowthIncrement = "10%";

// Add the log file.
idb.InstanceDatabaseLogFiles.Add(idb_log);

' Create log file and set properties.
Dim idb_log As InstanceDatabaseLogFile = _
    New InstanceDatabaseLogFile()

' Required properties.
idb_log.Name = "MyInst_LogFile1"
idb_log.Parent = idb
idb_log.FileName = "C:\NS\Default\MyInst_LogFile1.ldf"

' Optional properties.
idb_log.InitialSize = "3MB"
idb_log.MaxSize = "10MB"
idb_log.GrowthIncrement = "10%"

' Add the log file.
idb.InstanceDatabaseLogFiles.Add(idb_log)

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

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

Other Resources

Defining the Instance Database
NotificationServicesInstance Element (ICF)