.png)
sys.database_mirroring_witnesses (Transact-SQL)
Contains a row for every witness role that a server plays in a database mirroring partnership.
Column name | Data type | Description |
|---|---|---|
database_name | sysname | Name of the two copies of the database in the database mirroring session. |
principal_server_name | sysname | Name of partner server whose copy of the database is currently the principal database. |
mirror_server_name | sysname | Name of the partner server whose copy of the database is currently the mirror database. |
safety_level | tinyint | Transaction safety setting for updates on the mirror database: 0 = Unknown state 1 = Off (asynchronous) 2 = Full (synchronous) Using a witness for automatic failover requires full transaction safety, which is the default. |
safety_level_desc | nvarchar(60) | Description of safety guarantee of updates on the mirror database: UNKNOWN OFF FULL |
safety_sequence_number | int | Update sequence number for changes to safety_level. |
role_sequence_number | int | Update sequence number for changes to principal/mirror roles played by the mirroring partners. |
mirroring_guid | uniqueidentifier | Identifier of the mirroring partnership. |
family_guid | uniqueidentifier | Identifier of the backup family for the database. Used for detecting matching restore states. |
is_suspended | bit | Database mirroring is suspended. |
is_suspended_sequence_number | int | Sequence number for setting is_suspended. |
partner_sync_state | tinyint | Synchronization state of the mirroring session: 5 = The partners are synchronized. Failover is potentially possible. For information about the requirements for failover see, Synchronous Database Mirroring (High-Safety Mode). 6 = The partners are not synchronized. Failover is not possible now. |
partner_sync_state_desc | nvarchar(60) | Description of the synchronization state of the mirroring session: SYNCHRONIZED UNSYNCHRONIZED |
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
