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.
平台
开发平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
请参阅
参考
ApplicationDatabaseLogFile Class
ApplicationDatabaseLogFile Members
Microsoft.SqlServer.Management.Nmo Namespace