Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
FileState Enumeration
Collapse the table of content
Expand the table of content

FileState Enumeration

SQL Server 2014

Specifies the state of the file.

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

public enum FileState

Member nameDescription
DefunctThe file was dropped when it was not online.
OfflineThe file is not available for access and may not be present on the disk.
OnlineThe file is available for all operations.
RecoveringThe file is in recovering state.
RecoveryPendingThe recovery of the file is postponed.
RestoringThe file is being restored.
SuspectThe recovery of the file failed during an online restore process.

Community Additions

© 2015 Microsoft