Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
Public Enumeration RecoveryModel
public enum RecoveryModel
public enum class RecoveryModel
public enum RecoveryModel
public enum RecoveryModel
Members
Member name | Description |
---|---|
BulkLogged | Use the bulk logged recovery model. Bulk transactions are not logged. |
Full | Use the full recovery model. All transactions are logged and the log is not truncated. |
Simple | Use the simple recovery model. All transactions are logged but the log is truncated. |
Remarks
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.
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.