ApplicationDatabaseLogFile.GrowthIncrement Property
Gets or sets the increment by which the log file size increases when additional space is needed.
命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
語法
'宣告
Public Property GrowthIncrement As String
public string GrowthIncrement { get; set; }
public:
property String^ GrowthIncrement {
String^ get ();
void set (String^ value);
}
/** @property */
public String get_GrowthIncrement ()
/** @property */
public void set_GrowthIncrement (String value)
public function get GrowthIncrement () : String
public function set GrowthIncrement (value : String)
屬性值
A String, up to 16 characters in length, specifying the log file growth increment.
備註
The growth increment must be either the increment size or a percentage. If you specify an increment size, the value must be a nonnegative integer, 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 a percentage, the growth increment size is the specified percentage of the log file size at the time the increment occurs. To specify a percentage, use a percent (%) sign.
For more information, see the growth_increment 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