Share via

InstanceDatabaseLogFileCollection.Add Method

  • Article

Adds an InstanceDatabaseLogFile to the InstanceDatabaseLogFileCollection.

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

Syntax

'Declaration
Public Sub Add ( _
    instanceDatabaseLogFiles As InstanceDatabaseLogFile _
)

public void Add (
    InstanceDatabaseLogFile instanceDatabaseLogFiles
)

public:
void Add (
    InstanceDatabaseLogFile^ instanceDatabaseLogFiles
)

public void Add (
    InstanceDatabaseLogFile instanceDatabaseLogFiles
)

public function Add (
    instanceDatabaseLogFiles : InstanceDatabaseLogFile
)

Parameters

Example

The following examples show how to add a log file to the collection of log files for an instance database:

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

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

Other Resources

Defining the Instance Database
Database Element (ICF)
LogFile Element (ICF)