ApplicationDatabaseLogFile.MaxSize Property

Gets or sets the maximum size to which the log file can grow.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
Public Property MaxSize As String

public string MaxSize { get; set; }

public:
property String^ MaxSize {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_MaxSize ()

/** @property */
public void set_MaxSize (String value)

public function get MaxSize () : String

public function set MaxSize (value : String)

Значение свойства

A String, up to 32 characters in length, specifying the maximum log file size.

Замечания

The value for this property must either be the string UNLIMITED or a nonnegative integer indicating the maximum log file size, with an optional suffix to indicate the unit of measure: kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB). If the suffix is not specified, the default unit of measure is megabytes (MB).

If you specify UNLIMITED or do not specify a value, the file can grow until the disk is full or until the file is 2 TB.

Set the maximum log file size to at least 10 MB. Notification Services uses additional log space when you create and update the application.

For more information, see the max_size parameter in the CREATE DATABASE (Transact-SQL) topic.

Пример

The following examples show how to define a log file for the application 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)

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Другие ресурсы

Определение базы данных приложений
MaxSize Element for LogFile (ADF)