This topic has not yet been rated - Rate this topic

DataFile.IsOffline Property

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008
SQL Server 2005

Gets the Boolean property value that specifies whether the data file is offline or not.

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool IsOffline { get; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the data file is offline or online.If True, the data file is offline and unavailable. Otherwise, False (default).

Examples

Using Filegroups and Files to Store Data

Reference

DataFile Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Files and Filegroups Architecture

CREATE DATABASE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD