FileGrowth Property

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The FileGrowth property specifies the growth increment of the operating system file used to store table, index, or log data.

Syntax

object
.FileGrowth [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    A long integer

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFileGrowth(LPLONG pRetVal);
HRESULT SetFileGrowth(LONG NewValue);

Hinweise

The FileGrowth value is evaluated using the FileGrowthType property.

If FileGrowthType is SQLDMOGrowth_MB, the value represents the number of megabytes of disk space to allocate for incremental file growth.

If FileGrowthType is SQLDMOGrowth_Percent, the value represents a percentage and must be in the range from 1 through 100. Microsoft SQL Server never increments a file in units smaller than one megabyte, regardless of the result of the percentage of file size calculation.

Applies To:

DBFile Object

LogFile Object