Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IDatabaseMaintenanceFacet Interface

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)

public interface IDatabaseMaintenanceFacet : IDmfFacet

The IDatabaseMaintenanceFacet type exposes the following members.

Public propertyDataAndBackupOnSeparateLogicalVolumesA Boolean value that indicates if data and backup are on separate logical volumes.
Public propertyLastBackupDateGets a date and time for the last database backup.
Public propertyLastLogBackupDateGets a date and time for the last log backup.
Public propertyPageVerifyGets or sets the type of page integrity check that SQL Server performs when reading database pages.
Public propertyReadOnlyGets or sets a Boolean value that specifies if the database is read-only.
Public propertyRecoveryModelGets or set the database recovery model.
Public propertyStatusGets a DatabaseStatus object.
Public propertyTargetRecoveryTimeGets or sets the database for the target recovery time.

Community Additions

© 2015 Microsoft