DatabaseMaintenanceAdapter Class

Definition

The Database Maintenance facet has logical properties. It inherts from the DatabaseAdapter class.

public class DatabaseMaintenanceAdapter : Microsoft.SqlServer.Management.Smo.DatabaseAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IDatabaseMaintenanceFacet
type DatabaseMaintenanceAdapter = class
    inherit DatabaseAdapter
    interface IDatabaseMaintenanceFacet
    interface IDmfFacet
Public Class DatabaseMaintenanceAdapter
Inherits DatabaseAdapter
Implements IDatabaseMaintenanceFacet, IDmfFacet
Inheritance
DatabaseMaintenanceAdapter
Implements

Constructors

DatabaseMaintenanceAdapter(Database)

Properties

AutoClose

Returns true if the database has auto-close set to ON.

(Inherited from DatabaseAdapterBase)
AutoShrink

Returns true if the database has auto-shrink option enabled.

(Inherited from DatabaseAdapterBase)
DataAndBackupOnSeparateLogicalVolumes

Returns true if the database has its data and backup files on different logical volumes.

Database (Inherited from DatabaseAdapterBase)
DelayedDurability

Returns delayed durability setting of a database.

(Inherited from DatabaseAdapterBase)
IsSystemObject (Inherited from DatabaseAdapterBase)
LastBackupDate (Inherited from DatabaseAdapterBase)
LastLogBackupDate (Inherited from DatabaseAdapterBase)
PageVerify

Returns true if the PAGE_VERIFY setting of a database is set to CHECKSUM.

(Inherited from DatabaseAdapterBase)
ReadOnly

Returns true if the database is read-only.

(Inherited from DatabaseAdapterBase)
RecoveryModel

Returns the database recovery model.

(Inherited from DatabaseAdapterBase)
Size (Inherited from DatabaseAdapterBase)
Status (Inherited from DatabaseAdapterBase)
TargetRecoveryTime

Returns target recovery time setting of a database.

(Inherited from DatabaseAdapterBase)
Trustworthy (Inherited from DatabaseAdapterBase)

Methods

Alter() (Inherited from DatabaseAdapterBase)
DataFileVolumeNotIn(List<String>)

This method compares the drive letter from files in the filegroups against the drive letters in the checkDrives parameter. If any one file drive letter is in the list of checkVolumes, then the function returns true otherwise it returns false.

(Inherited from DatabaseAdapterBase)
GetVolume(String) (Inherited from DatabaseAdapterBase)
Refresh() (Inherited from DatabaseAdapterBase)

Applies to