InstanceDatabaseLogFile Constructor ()

Article
12/03/2008

Initializes a new instance of the InstanceDatabaseLogFile class.

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

Syntax

'Declaration
Public Sub New

public InstanceDatabaseLogFile ()

public:
InstanceDatabaseLogFile ()

public InstanceDatabaseLogFile ()

public function InstanceDatabaseLogFile ()

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

If you use the default constructor, you must immediately set the Name property and then set the Parent property. You can then set the required FileName property and other optional properties.

Example

The following examples show how to use this 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)

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.

Share via