Jaa

ApplicationDatabaseLogFile Constructor ()

  • Artikkeli

Initializes a new instance of the ApplicationDatabaseLogFile class.

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

Syntax

'Declaration
Public Sub New

public ApplicationDatabaseLogFile ()

public:
ApplicationDatabaseLogFile ()

public ApplicationDatabaseLogFile ()

public function ApplicationDatabaseLogFile ()

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 other properties.

You also must set the FileName property. Other properties are optional.

Example

The following examples show how to use this default constructor:

// Define log file and set properties.
ApplicationDatabaseLogFile adb_log = new ApplicationDatabaseLogFile();

// Set required properties.
adb_log.Name = "MyApp_LogFile1";
adb_log.Parent = adb;
adb_log.FileName = @"C:\NS\Default\MyApp_LogFile1.ldf";

// Set optional properties.
adb_log.InitialSize = "5MB";
adb_log.MaxSize = "20MB";
adb_log.GrowthIncrement = "10%";

// Add the log file.
adb.ApplicationDatabaseLogFiles.Add(adb_log);

' Define log file and set properties.
Dim adb_log As ApplicationDatabaseLogFile = _
    New ApplicationDatabaseLogFile()

' Set required properties.
adb_log.Name = "MyApp_LogFile1"
adb_log.Parent = adb
adb_log.FileName = "C:\NS\Default\MyApp_LogFile1.ldf"

' Set optional properties.
adb_log.InitialSize = "5MB"
adb_log.MaxSize = "20MB"
adb_log.GrowthIncrement = "10%"

' Add the log file.
adb.ApplicationDatabaseLogFiles.Add(adb_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.

See Also

Reference

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

Other Resources

CREATE DATABASE (Transact-SQL)
Defining the Application Database
LogFile Element (ADF)