SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
IDatabaseOptions Interface
IDatabaseOptions Properties
AnsiNullDefault Property
AnsiNullsEnabled Property
AnsiPaddingEnabled Property
AnsiWarningsEnabled Property
ArithmeticAbortEnabled Property
AutoClose Property
AutoCreateStatisticsEnabled Property
AutoShrink Property
AutoUpdateStatisticsAsync Property
AutoUpdateStatisticsEnabled Property
BrokerEnabled Property
ChangeTrackingAutoCleanUp Property
ChangeTrackingEnabled Property
ChangeTrackingRetentionPeriod Property
ChangeTrackingRetentionPeriodUnits Property
CloseCursorsOnCommitEnabled Property
Collation Property
CompatibilityLevel Property
ConcatenateNullYieldsNull Property
CreateDate Property
DatabaseOwnershipChaining Property
DatabaseSnapshotBaseName Property
DateCorrelationOptimization Property
DefaultFileGroup Property
DefaultFileStreamFileGroup Property
EncryptionEnabled Property
HonorBrokerPriority Property
ID Property
IsParameterizationForced Property
IsReadCommittedSnapshotOn Property
IsSystemObject Property
IsUpdateable Property
LocalCursorsDefault Property
MirroringTimeout Property
Name Property
NumericRoundAbortEnabled Property
Owner Property
PageVerify Property
PrimaryFilePath Property
QuotedIdentifiersEnabled Property
ReadOnly Property
RecoveryModel Property
RecursiveTriggersEnabled Property
TargetRecoveryTime Property
Trustworthy Property
UserAccess Property
Expand Minimize
This topic has not yet been rated - Rate this topic

IDatabaseOptions.RecoveryModel Property

SQL Server 2012

Gets or sets the recovery model for the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
[DisplayDescriptionKeyAttribute("Database_RecoveryModelDesc")]
[DisplayNameKeyAttribute("Database_RecoveryModelName")]
RecoveryModel RecoveryModel { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.RecoveryModel
A RecoveryModel object value that specifies the recovery model that is currently in operation on the database.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.