共用方式為


InstanceDatabaseLogFile.GrowthIncrement Property

Gets or sets the increment by which the log file size will increase 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 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

其他資源

定義執行個體資料庫
GrowthIncrement Element for LogFile (ICF)