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

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 datetime for the last database backup.
Public propertyLastLogBackupDateGets a datetime 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.

Community Additions

© 2015 Microsoft