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

RecoveryModel Enumeration

The RecoveryModel enumeration contains values that are used to specify the type of recovery model.

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

public enum RecoveryModel
public enum RecoveryModel
public enum RecoveryModel

Member nameDescription
BulkLoggedUse the bulk logged recovery model. Bulk transactions are not logged.
FullUse the full recovery model. All transactions are logged and the log is not truncated.
SimpleUse the simple recovery model. All transactions are logged but the log is truncated.

The RecoveryModel enumeration class is served by the RecoveryModel property.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft