DatabaseMaintenanceAdapter Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Smo

Assembly:: Microsoft.SqlServer.Smo.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: Object

DatabaseAdapterBase

DatabaseAdapter
DatabaseMaintenanceAdapter

Implements: IDmfFacet IDatabaseMaintenanceFacet

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

共用方式為