ApplicationDatabaseFile.GrowthIncrement Property

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

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
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)

Eigenschaftswert

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

Hinweise

This property 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 database size at the time the increment occurs. To specify a percentage, use the percent (%) sign.

For more information, see the growth_increment parameter in CREATE DATABASE (Transact-SQL).

Beispiel

The following examples show how to define an application database file:

// Define and add a filegroup
ApplicationDatabaseFileGroup adb_fg = 
    new ApplicationDatabaseFileGroup(adb, "PRIMARY");
adb.ApplicationDatabaseFileGroups.Add(adb_fg);

// Define and add a database file
ApplicationDatabaseFile adb_file1 = 
    new ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1");
adb_file1.FileName = @"C:\NS\Full\MyApp_PrimaryFile1.mdf";
adb_file1.InitialSize = "10MB";
adb_file1.MaxSize = "50MB";
adb_file1.GrowthIncrement = "10%";
adb_fg.ApplicationDatabaseFiles.Add(adb_file1);

' Define and add a filegroup
Dim adb_fg As ApplicationDatabaseFileGroup = _
    New ApplicationDatabaseFileGroup(adb, "PRIMARY")
adb.ApplicationDatabaseFileGroups.Add(adb_fg)

' Define and add a database file
Dim adb_file1 As ApplicationDatabaseFile = _
    New ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1")
adb_file1.FileName = "C:\NS\Full\MyApp_PrimaryFile1.mdf"
adb_file1.InitialSize = "10MB"
adb_file1.MaxSize = "50MB"
adb_file1.GrowthIncrement = "10%"
adb_fg.ApplicationDatabaseFiles.Add(adb_file1)

Threadsicherheit

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.