This topic has not yet been rated - Rate this topic

IDatabaseMaintenanceFacet Interface

SQL Server 2012

Interface that defined methods and properties for the database maintenance facet.

This API is not CLS-compliant.

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

Syntax

C++

JScript

'Declaration
<DisplayDescriptionKeyAttribute("IDatabaseMaintenanceFacet_Desc")> _
<DisplayNameKeyAttribute("IDatabaseMaintenanceFacet_Name")> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<CLSCompliantAttribute(False)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
Public Interface IDatabaseMaintenanceFacet _
	Inherits IDmfFacet
'Usage
Dim instance As IDatabaseMaintenanceFacet

The IDatabaseMaintenanceFacet type exposes the following members.

Properties

	Name	Description
	DataAndBackupOnSeparateLogicalVolumes	A Boolean value that indicates if data and backup are on separate logical volumes.
	LastBackupDate	Gets a date and time for the last database backup.
	LastLogBackupDate	Gets a date and time for the last log backup.
	PageVerify	Gets or sets the type of page integrity check that SQL Server performs when reading database pages.
	ReadOnly	Gets or sets a Boolean value that specifies if the database is read-only.
	RecoveryModel	Gets or set the database recovery model.
	Status	Gets a DatabaseStatus object.
	TargetRecoveryTime	Gets or sets the database for the target recovery time.

Top

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD