TechNet
Export (0) Print
Expand All

DatabaseReplicaState Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAvailabilityDatabaseName

Gets the name of the availability database.

System_CAPS_pubpropertyAvailabilityDateabaseId

Gets the identifier of the database within the availability group.

System_CAPS_pubpropertyAvailabilityGroupId

Gets the identifier of the availability group to which the database belongs.

System_CAPS_pubpropertyAvailabilityGroupName

Gets the name of the availability group.

System_CAPS_pubpropertyAvailabilityReplicaId

Gets the identifier of the availability replica within the availability group.

System_CAPS_pubpropertyAvailabilityReplicaServerName

Gets the server name of the availability replica.

System_CAPS_pubpropertyDatabaseId

Gets the identifier of the database, unique within an instance of SQL Server.

System_CAPS_pubpropertyEndOfLogLSN

Gets the LSN of the most recent log record flushed to disk.

System_CAPS_pubpropertyEstimatedDataLoss

Gets the estimated data loss.

System_CAPS_pubpropertyEstimatedRecoveryTime

Gets the estimated recovery time.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyFileStreamSendRate

Gets the rate at which the files are sent to the secondary replica.

System_CAPS_pubpropertyIsFailoverReady

Gets or sets a value that indicates whether the database is marked synchronized in the cluster.

System_CAPS_pubpropertyIsJoined

Gets or sets a value that indicates whether the availability database has a physical replica on the server instance.

System_CAPS_pubpropertyIsLocal

Gets or sets a value that indicates whether the database is local to the instance.

System_CAPS_pubpropertyIsSuspended

Gets a value that indicates whether the state of the database replica is suspended.

System_CAPS_pubpropertyLastCommitLSN

Gets the LSN of the last commit record.

System_CAPS_pubpropertyLastCommitTime

Gets the time corresponding to the last commit record.

System_CAPS_pubpropertyLastHardenedLSN

Gets the start of the log block that contained the latest log records that were written to disk.

System_CAPS_pubpropertyLastHardenedTime

Gets the time when the log-block identifier for the last hardened LSN.

System_CAPS_pubpropertyLastReceivedLSN

Gets the last log block that was received on this secondary replica for this database.

System_CAPS_pubpropertyLastReceivedTime

Gets the time when the log block identifier was last received on the secondary.

System_CAPS_pubpropertyLastRedoneLSN

Gets the last log record that was redone on the secondary database.

System_CAPS_pubpropertyLastRedoneTime

Gets the time when the last log record was redone on the secondary database.

System_CAPS_pubpropertyLastSentLSN

Gets the last block of transaction log records that was sent to this secondary replica for this database.

System_CAPS_pubpropertyLastSentTime

Gets the time when the last log block was sent.

System_CAPS_pubpropertyLogSendQueueSize

Gets the amount of log records in the log files of the primary database that has not been sent to the secondary replica.

System_CAPS_pubpropertyLogSendRate

Gets the rate at which log records are being sent to the secondary replica.

System_CAPS_pubpropertyParent

Gets the AvailabilityGroup object that is the parent of the DatabaseReplicaState object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyRecoveryLSN

Gets the end of the transaction log before the replica writes any new log records after recovery failover.

System_CAPS_pubpropertyRedoQueueSize

Gets the amount of log records in the log files of the secondary replica that has not yet been redone.

System_CAPS_pubpropertyRedoRate

Gets the rate at which the log records are being redone.

System_CAPS_pubpropertyReplicaAvailabilityMode

Gets the availability mode of the availability replica.

System_CAPS_pubpropertyReplicaRole

Gets the role of the availability replica.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertySuspendReason

Gets the reason for a database replica to be in suspended state.

System_CAPS_pubpropertySynchronizationPerformance

Gets the performance of the synchronization for the database.

System_CAPS_pubpropertySynchronizationState

Gets the state of the availability database synchronization.

System_CAPS_pubpropertyTruncationLSN

Gets the log truncation value, which may be higher than the local truncation LSN if local log truncation is blocked.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft