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
Public ReadOnly Property IsSparse As Boolean
public bool IsSparse { get; }
public:
property bool IsSparse {
bool get ();
}
/** @property */
public boolean get_IsSparse ()
public function get IsSparse () : boolean
Property Value
A Boolean value that specifies whether the data file is sparse. If True, the data file is sparse. If False (default), the data file is dense.
Remarks
Updated text:
Sparse files are described in How Database Snapshots Work.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Example
How to: Add FileGroups and DataFiles to a Database in Visual Basic .NET
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
DataFile Class
DataFile Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Understanding Sparse File Sizes in Database Snapshots
Using Filegroups and Files to Store Data
Physical Database Files and Filegroups
CREATE DATABASE (Transact-SQL)
Change History
Release |
History |
New content:
|