DatabaseMaintenanceAdapter DatabaseMaintenanceAdapter DatabaseMaintenanceAdapter Class

Definition

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

public ref class DatabaseMaintenanceAdapter : Microsoft::SqlServer::Management::Smo::DatabaseAdapter, Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet, Microsoft::SqlServer::Management::Smo::IDatabaseMaintenanceFacet
public class DatabaseMaintenanceAdapter : Microsoft.SqlServer.Management.Smo.DatabaseAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IDatabaseMaintenanceFacet
Public Class DatabaseMaintenanceAdapter
Inherits DatabaseAdapter
Implements IDatabaseMaintenanceFacet, IDmfFacet
Inheritance
DatabaseMaintenanceAdapterDatabaseMaintenanceAdapterDatabaseMaintenanceAdapter
Implements

Constructors

DatabaseMaintenanceAdapter(Database) DatabaseMaintenanceAdapter(Database) DatabaseMaintenanceAdapter(Database)

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

Properties

AutoClose AutoClose AutoClose

Gets or sets a value that indicates whether the AutoClose is on.

(Inherited from DatabaseAdapterBase)
AutoShrink AutoShrink AutoShrink

Gets or sets a value that indicates whether the AutoShrink is on.

(Inherited from DatabaseAdapterBase)
DataAndBackupOnSeparateLogicalVolumes DataAndBackupOnSeparateLogicalVolumes DataAndBackupOnSeparateLogicalVolumes

Returns a Boolean value that specifies whether the data and backup files are on separate logical volumes.

Database Database Database

Gets the database that is associated with the AdapterBase object.

(Inherited from DatabaseAdapterBase)
DelayedDurability DelayedDurability DelayedDurability

Gets or sets the delayed durability setting of a database.

(Inherited from DatabaseAdapterBase)
IsSystemObject IsSystemObject IsSystemObject

Gets the Boolean value that specifies whether the adapter base is a system object or not.

(Inherited from DatabaseAdapterBase)
LastBackupDate LastBackupDate LastBackupDate

Gets a Datetime object that indicates the time of the last backup.

(Inherited from DatabaseAdapterBase)
LastLogBackupDate LastLogBackupDate LastLogBackupDate

Gets a Datetime object that indicates the time of the last log backup.

(Inherited from DatabaseAdapterBase)
PageVerify PageVerify PageVerify

Gets a Boolean value that indicates whether the PageVerify setting is set to checksum.

(Inherited from DatabaseAdapterBase)
ReadOnly ReadOnly ReadOnly

Gets or sets a value that indicates whether database is set to read-only.

(Inherited from DatabaseAdapterBase)
RecoveryModel RecoveryModel RecoveryModel

Gets or sets the database adapter recovery model.

(Inherited from DatabaseAdapterBase)
Size Size Size

Gets the database size in megabytes (MB).

(Inherited from DatabaseAdapterBase)
Status Status Status

Gets the database status.

(Inherited from DatabaseAdapterBase)
TargetRecoveryTime TargetRecoveryTime TargetRecoveryTime

Returns target recovery time setting of a database.

(Inherited from DatabaseAdapterBase)
Trustworthy Trustworthy Trustworthy

Gets or sets a value that indicates whether database is set to Trustworthy.

(Inherited from DatabaseAdapterBase)

Methods

Alter() Alter() Alter()

Alters database adapter base properties.

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

Returns a Boolean value that is associated with the database adapter base.

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

Returns the volume name as it appears in the PATH variable.

(Inherited from DatabaseAdapterBase)
Refresh() Refresh() Refresh()

Refreshes the database adapter.

(Inherited from DatabaseAdapterBase)

Applies to