InstanceDatabaseLogFile.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 instance.
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 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)
執行緒安全性
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 的硬體和軟體需求＞。
請參閱
參考
InstanceDatabaseLogFile Class
InstanceDatabaseLogFile Members
Microsoft.SqlServer.Management.Nmo Namespace