Classe DatabaseReplicaState
Represents the runtime state of a database that’s participating in an availability group. This database may be located on any of the replicas that compose the availability group.
Gerarchia di ereditarietà
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.DatabaseReplicaState
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class DatabaseReplicaState _
Inherits SqlSmoObject
'Utilizzo
Dim instance As DatabaseReplicaState
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public sealed class DatabaseReplicaState : SqlSmoObject
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public ref class DatabaseReplicaState sealed : public SqlSmoObject
[<SealedAttribute>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
type DatabaseReplicaState =
class
inherit SqlSmoObject
end
public final class DatabaseReplicaState extends SqlSmoObject
Nel tipo DatabaseReplicaState sono esposti i membri seguenti.
Proprietà
Nome | Descrizione | |
---|---|---|
![]() |
AvailabilityDatabaseName | Gets the name of the availability database. |
![]() |
AvailabilityDateabaseId | Gets the identifier of the database within the availability group. |
![]() |
AvailabilityGroupId | Gets the identifier of the availability group to which the database belongs. |
![]() |
AvailabilityGroupName | Gets the name of the availability group. |
![]() |
AvailabilityReplicaId | Gets the identifier of the availability replica within the availability group. |
![]() |
AvailabilityReplicaServerName | Gets the server name of the availability replica. |
![]() |
DatabaseId | Gets the identifier of the database, unique within an instance of SQL Server. |
![]() |
EndOfLogLSN | Gets the LSN of the most recent log record flushed to disk. |
![]() |
EstimatedDataLoss | Gets the estimated data loss. |
![]() |
EstimatedRecoveryTime | Gets the estimated recovery time. |
![]() |
FileStreamSendRate | Gets the rate at which the files are sent to the secondary replica. |
![]() |
IsFailoverReady | Gets or sets a value that indicates whether the database is marked synchronized in the cluster. |
![]() |
IsJoined | Gets or sets a value that indicates whether the availability database has a physical replica on the server instance. |
![]() |
IsLocal | Gets or sets a value that indicates whether the database is local to the instance. |
![]() |
IsSuspended | Gets a value that indicates whether the state of the database replica is suspended. |
![]() |
LastCommitLSN | Gets the LSN of the last commit record. |
![]() |
LastCommitTime | Gets the time corresponding to the last commit record. |
![]() |
LastHardenedLSN | Gets the start of the log block that contained the latest log records that were written to disk. |
![]() |
LastHardenedTime | Gets the time when the log-block identifier for the last hardened LSN. |
![]() |
LastReceivedLSN | Gets the last log block that was received on this secondary replica for this database. |
![]() |
LastReceivedTime | Gets the time when the log block identifier was last received on the secondary. |
![]() |
LastRedoneLSN | Gets the last log record that was redone on the secondary database. |
![]() |
LastRedoneTime | Gets the time when the last log record was redone on the secondary database. |
![]() |
LastSentLSN | Gets the last block of transaction log records that was sent to this secondary replica for this database. |
![]() |
LastSentTime | Gets the time when the last log block was sent. |
![]() |
LogSendQueueSize | Gets the amount of log records in the log files of the primary database that has not been sent to the secondary replica. |
![]() |
LogSendRate | Gets the rate at which log records are being sent to the secondary replica. |
![]() |
Parent | Gets the AvailabilityGroup object that is the parent of the DatabaseReplicaState object. |
![]() |
Properties | Gets a collection of Property objects that represent the object properties. Ereditato da SqlSmoObject. |
![]() |
RecoveryLSN | Gets the end of the transaction log before the replica writes any new log records after recovery failover. |
![]() |
RedoQueueSize | Gets the amount of log records in the log files of the secondary replica that has not yet been redone. |
![]() |
RedoRate | Gets the rate at which the log records are being redone. |
![]() |
ReplicaAvailabilityMode | Gets the availability mode of the availability replica. |
![]() |
ReplicaRole | Gets the role of the availability replica. |
![]() |
State | Gets the state of the referenced object. Ereditato da SmoObjectBase. |
![]() |
SuspendReason | Gets the reason for a database replica to be in suspended state. |
![]() |
SynchronizationPerformance | Gets the performance of the synchronization for the database. |
![]() |
SynchronizationState | Gets the state of the availability database synchronization. |
![]() |
TruncationLSN | Gets the log truncation value, which may be higher than the local truncation LSN if local log truncation is blocked. |
![]() |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. Ereditato da SqlSmoObject. |
![]() |
UserData | Gets or sets user-defined data associated with the referenced object. Ereditato da SmoObjectBase. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
![]() |
Discover | Discovers a list of type Object. Ereditato da SqlSmoObject. |
![]() |
Equals | Ereditato da Object. |
![]() |
FormatSqlVariant | Formats an object as SqlVariant type. Ereditato da SqlSmoObject. |
![]() |
GetContextDB | Gets the context database that is associated with this object. Ereditato da SqlSmoObject. |
![]() |
GetDBName | Gets the database name that is associated with the object. Ereditato da SqlSmoObject. |
![]() |
GetHashCode | Ereditato da Object. |
![]() |
GetPropValue | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. |
![]() |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. |
![]() |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. |
![]() |
GetServerObject | Gets the server of the SqlSmoObject object. Ereditato da SqlSmoObject. |
![]() |
GetType | Ereditato da Object. |
![]() |
Initialize() | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. |
![]() |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. |
![]() |
IsObjectInitialized | Verifies whether the object has been initialized. Ereditato da SqlSmoObject. |
![]() |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. Ereditato da SqlSmoObject. |
![]() |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. Ereditato da SqlSmoObject. |
![]() |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. Ereditato da SqlSmoObject. |
![]() |
ToString | Returns a String that represents the referenced object. Ereditato da SqlSmoObject. |
![]() |
Validate | Validates the state of an object. Ereditato da SmoObjectBase. |
In alto
Eventi
Nome | Descrizione | |
---|---|---|
![]() |
PropertyChanged | Represents the event that occurs when a property is changed. Ereditato da SqlSmoObject. |
![]() |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. Ereditato da SqlSmoObject. |
In alto
Implementazioni esplicite dell'interfaccia
Nome | Descrizione | |
---|---|---|
![]() ![]() |
IAlienObject.Discover | Discovers any dependencies. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.GetDomainRoot | Returns the root of the domain. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.GetParent | Gets the parent of this object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.GetPropertyType | Gets the type of the specified property. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.GetPropertyValue | Gets the value of the specified property. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. Ereditato da SqlSmoObject. |
![]() ![]() |
IAlienObject.SetPropertyValue | Sets the property value. Ereditato da SqlSmoObject. |
![]() ![]() |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. Ereditato da SqlSmoObject. |
In alto
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.