Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Data Element | MSSFOMESSAGE |
| Short Description | Failover message |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | CHAR | Character String |
| Length | 50 | |
| Decimal Places | 0 | |
| Output Length | 50 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 8 | Failover |
| Medium | 16 | Failover message |
| Long | 16 | Failover message |
| Heading | 16 | Failover message |
Documentation
Definition
This message describes the failover configuration of a database. It has the following format:
<failover_type>;Synchronous/Asynchronous;<failover_state>
Where <failover_type> is either "Mirrored" or "Always-On". Database mirroring has been supported since SQL Server 2005. The Always-On technology was introduced with SQL Server 2012.
If <failover_type> is "Mirrored" and the mirroring_safety_level field in table sys.database_mirroring has the value 2, then "Synchronous" is specified. Otherwise "Asynchronous" is specified. The <failover_state> is set in this case to the value of mirroring_state_desc in table sys.database_mirroring.
If <failover_type is "Always-On", then "Synchronous" is specified if at least one availability replica is running in synchronous mode. Otherwise "Asynchronous" is specified. The <failover_state> is set to the value of field synchronization_state_desc from table sys.dm_hadr_database_replica_states.
History
| Last changed by/on | SAP | 20140117 |
| SAP Release Created in | 740 |
