SYSMIRRORSERVER system view

The underlying system table for this view is ISYSMIRRORSERVER.

Column name Data type Description
object_id UNSIGNED BIGINT A unique identifier for the mirror server.
server_name CHAR(128) The name of the server.
server_type CHAR(20) The type of server. The value can be one of PRIMARY, MIRROR, ARBITER, PARTNER, or COPY.
parent UNSIGNED BIGINT

The parent server. If the value is NULL, then the server is the primary or mirror server in a database mirroring system.

If there is a value in this column, it is the ID of the server that is the parent of the current server.

alternate_parent UNSIGNED BIGINT The ID of the server that is used as an alternate parent if the current parent becomes unavailable.
 Constraints on underlying system table
 See also