Export (0) Print
Expand All

DatabaseReplicaState Properties

The DatabaseReplicaState type exposes the following members.

  Name Description
Public property AvailabilityDatabaseName Gets the name of the availability database.
Public property AvailabilityDateabaseId Gets the identifier of the database within the availability group.
Public property AvailabilityGroupId Gets the identifier of the availability group to which the database belongs.
Public property AvailabilityGroupName Gets the name of the availability group.
Public property AvailabilityReplicaId Gets the identifier of the availability replica within the availability group.
Public property AvailabilityReplicaServerName Gets the server name of the availability replica.
Public property DatabaseId Gets the identifier of the database, unique within an instance of SQL Server.
Public property EndOfLogLSN Gets the LSN of the most recent log record flushed to disk.
Public property EstimatedDataLoss Gets the estimated data loss.
Public property EstimatedRecoveryTime Gets the estimated recovery time.
Public property FileStreamSendRate Gets the rate at which the files are sent to the secondary replica.
Public property IsFailoverReady Gets or sets a value that indicates whether the database is marked synchronized in the cluster.
Public property IsJoined Gets or sets a value that indicates whether the availability database has a physical replica on the server instance.
Public property IsLocal Gets or sets a value that indicates whether the database is local to the instance.
Public property IsSuspended Gets a value that indicates whether the state of the database replica is suspended.
Public property LastCommitLSN Gets the LSN of the last commit record.
Public property LastCommitTime Gets the time corresponding to the last commit record.
Public property LastHardenedLSN Gets the start of the log block that contained the latest log records that were written to disk.
Public property LastHardenedTime Gets the time when the log-block identifier for the last hardened LSN.
Public property LastReceivedLSN Gets the last log block that was received on this secondary replica for this database.
Public property LastReceivedTime Gets the time when the log block identifier was last received on the secondary.
Public property LastRedoneLSN Gets the last log record that was redone on the secondary database.
Public property LastRedoneTime Gets the time when the last log record was redone on the secondary database.
Public property LastSentLSN Gets the last block of transaction log records that was sent to this secondary replica for this database.
Public property LastSentTime Gets the time when the last log block was sent.
Public property LogSendQueueSize Gets the amount of log records in the log files of the primary database that has not been sent to the secondary replica.
Public property LogSendRate Gets the rate at which log records are being sent to the secondary replica.
Public property Parent Gets the AvailabilityGroup object that is the parent of the DatabaseReplicaState object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property RecoveryLSN Gets the end of the transaction log before the replica writes any new log records after recovery failover.
Public property RedoQueueSize Gets the amount of log records in the log files of the secondary replica that has not yet been redone.
Public property RedoRate Gets the rate at which the log records are being redone.
Public property ReplicaAvailabilityMode Gets the availability mode of the availability replica.
Public property ReplicaRole Gets the role of the availability replica.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property SuspendReason Gets the reason for a database replica to be in suspended state.
Public property SynchronizationPerformance Gets the performance of the synchronization for the database.
Public property SynchronizationState Gets the state of the availability database synchronization.
Public property TruncationLSN Gets the log truncation value, which may be higher than the local truncation LSN if local log truncation is blocked.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft