Share via

  • Article

DataFile.IsSparse Property

Gets the Boolean value that specifies whether the file is a sparse file. Sparse files are used in database snapshots.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute> _
Public ReadOnly Property IsSparse As Boolean
    Get
'Usage
Dim instance As DataFile
Dim value As Boolean

value = instance.IsSparse

[SfcPropertyAttribute]
public bool IsSparse { get; }

[SfcPropertyAttribute]
public:
property bool IsSparse {
    bool get ();
}

[<SfcPropertyAttribute>]
member IsSparse : bool

function get IsSparse () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether the data file is sparse.
If True, the data file is sparse. Otherwise, False (default).

Remarks

Sparse files are described in How Database Snapshots Work.