InstanceDatabaseLogFile.GrowthIncrement Property

Gets or sets the increment by which the log file size will increase when additional space is needed.

Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
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)

Valor de propiedad

A String, up to 16 characters in length, specifying the log file growth increment.

Notas

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.

Ejemplo

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)

Seguridad para subprocesos

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.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

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

Otros recursos

Definir la base de datos de instancia
GrowthIncrement Element for LogFile (ICF)