Share via

InstanceDatabaseOptions.InstanceDatabaseLogFiles Property

  • Article

Gets the collection of InstanceDatabaseLogFile objects for the Notification ServicesInstance.

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

Syntax

'Declaration
Public ReadOnly Property InstanceDatabaseLogFiles As InstanceDatabaseLogFileCollection

public InstanceDatabaseLogFileCollection InstanceDatabaseLogFiles { get; }

public:
property InstanceDatabaseLogFileCollection^ InstanceDatabaseLogFiles {
    InstanceDatabaseLogFileCollection^ get ();
}

/** @property */
public InstanceDatabaseLogFileCollection get_InstanceDatabaseLogFiles ()

public function get InstanceDatabaseLogFiles () : InstanceDatabaseLogFileCollection

Property Value

An InstanceDatabaseLogFileCollection collection.

Remarks

Use the methods of the InstanceDatabaseLogFileCollection class to add or remove InstanceDatabaseLogFile objects.

Example

The following examples show how to define a filegroup for an instance database and then add it to the collection of filegroups:

InstanceDatabaseLogFile idb_log = 
    new InstanceDatabaseLogFile(idb, "MyInst_LogFile1");
idb_log.FileName = @"C:\NS\Full\MyInst_LogFile1.ldf";
idb_log.InitialSize = "3MB";
idb_log.MaxSize = "10MB";
idb_log.GrowthIncrement = "10%";
idb.InstanceDatabaseLogFiles.Add(idb_log);

Dim idb_log As InstanceDatabaseLogFile = _
    New InstanceDatabaseLogFile(idb, "MyInst_LogFile1")
idb_log.FileName = "C:\NS\Full\MyInst_LogFile1.ldf"
idb_log.InitialSize = "3MB"
idb_log.MaxSize = "10MB"
idb_log.GrowthIncrement = "10%"
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

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

Other Resources

Defining the Instance Database