DataFile.IsSparse Property

Article
07/16/2015

Applies To: SQL Server 2016 Preview

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

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Matrix)]
public bool IsSparse { get; }

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Standalone | SfcPropertyFlags::Matrix)]
property bool IsSparse {
    bool get();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Matrix)>]
member IsSparse : bool with get

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Matrix)>
Public ReadOnly Property IsSparse As 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 .Unable to find linked topic '5079d79f-aee4-49d2-b885-7689d0ad0fc7'.

Examples

Legacy Code Example

Using Filegroups and Files to Store Data