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(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property IsSparse As Boolean
Get
'Usage
Dim instance As DataFile
Dim value As Boolean
value = instance.IsSparse
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool IsSparse { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool IsSparse {
bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
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.
Examples
Using Filegroups and Files to Store Data
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
View the Size of the Sparse File of a Database Snapshot (Transact-SQL)