Export (0) Print
Expand All

DataFile Properties

The DataFile type exposes the following members.

  Name Description
Public property AvailableSpace Gets the amount of available space in the data file in KB.
Public property BytesReadFromDisk Gets the number of bytes read from disk.
Public property BytesWrittenToDisk Gets the number of bytes written to disk.
Public property FileName Gets or sets the data file name.
Public property FileSegments Gets the collection of file segments. (Inherited from DatabaseFile.)
Public property Growth Gets or sets the growth increment for the data file in KB or percent.
Public property GrowthType Gets or sets the growth type for the data file in kilobytes or percent.
Public property ID Gets the ID value that uniquely identifies the data file.
Public property IsOffline Gets the Boolean property value that specifies whether the data file is offline or not.
Public property IsPrimaryFile Gets the Boolean property value that specifies whether the data file is the primary file of the database.
Public property IsReadOnly Gets the Boolean property value that specifies whether the data file is read-only or can be updated.
Public property IsReadOnlyMedia Gets the Boolean property value that specifies whether the data file is stored on read-only media.
Public property IsSparse Gets the Boolean value that specifies whether the file is a sparse file. Sparse files are used in database snapshots.
Public property MaxSize Gets or set the maximum size to which the data file can grow in KB.
Public property Name Gets or sets the name of the object. (Inherited from NamedSmoObject.)
Public property NumberOfDiskReads Gets the number of disk reads.
Public property NumberOfDiskWrites Gets the number of disk writes.
Public property Parent Gets or sets the FileGroup object that is the parent of the DataFile object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property Size Gets or sets the current size of the data file in KB.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UsedSpace Gets the amount of used space in the data file in KB.
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Public property VolumeFreeSpace Gets the volume free space in bytes.
Top

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode.
Top

Community Additions

ADD
Show:
© 2014 Microsoft