Share via

ApplicationDatabaseLogFileCollection.Add Method

  • Article

Adds an ApplicationDatabaseLogFile to the ApplicationDatabaseLogFileCollection.

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

Syntax

'Declaration
Public Sub Add ( _
    applicationDatabaseLogFiles As ApplicationDatabaseLogFile _
)

public void Add (
    ApplicationDatabaseLogFile applicationDatabaseLogFiles
)

public:
void Add (
    ApplicationDatabaseLogFile^ applicationDatabaseLogFiles
)

public void Add (
    ApplicationDatabaseLogFile applicationDatabaseLogFiles
)

public function Add (
    applicationDatabaseLogFiles : ApplicationDatabaseLogFile
)

Parameters

Remarks

Each ApplicationDatabaseLogFile must be unique within the application.

Example

The following examples show how to define a log file for the application database and add it to the collection of log files for the database:

ApplicationDatabaseLogFile adb_log = 
    new ApplicationDatabaseLogFile(adb, "MyApp_LogFile1");
adb_log.FileName = @"C:\NS\Full\MyApp_LogFile1.ldf";
adb_log.InitialSize = "5MB";
adb_log.MaxSize = "20MB";
adb_log.GrowthIncrement = "10%";
adb.ApplicationDatabaseLogFiles.Add(adb_log);

Dim adb_log As ApplicationDatabaseLogFile = _
    New ApplicationDatabaseLogFile(adb, "MyApp_LogFile1")
adb_log.FileName = "C:\NS\Full\MyApp_LogFile1.ldf"
adb_log.InitialSize = "5MB"
adb_log.MaxSize = "20MB"
adb_log.GrowthIncrement = "10%"
adb.ApplicationDatabaseLogFiles.Add(adb_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

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

Other Resources

Defining the Application Database
Database Element (ADF)
LogFile Element (ADF)