Partilhar via


LogFile.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

LogFile Class
LogFile 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:
  • Modified the description of the IsSparse property.