Specifies the type of failover method the driver uses.
Valid values
connect | extended | select
Behavior
If set to connect, the driver provides failover protection for new connections only.
If set to extended, the driver provides failover protection for new and lost connections, but not any work in progress.
If set to select, the driver provides failover protection for new and lost connections. In addition, it preserves the state of work performed by the last Select statement executed on the Statement object.
Notes
The AlternateServers property specifies one or multiple alternate servers for failover and is required for all failover methods. To turn off failover, do not specify a value for the AlternateServers property.
The FailoverGranularity property determines which action the driver takes if exceptions occur during the failover process.
The FailoverPreconnect property specifies whether the driver tries to connect to multiple database servers (primary and alternate) at the same time.
When MultiSubnetFailover is enabled, the driver does not support FailoverMode=select. If MultiSubnetFailover=true and FailoverMode=select, the driver downgrades the FailoverMode to extended and provides the following warning.
failoverMode=select is not supported for AlwaysOn Availability Group,
downgraded to failoverMode=extended
The AlternateServers property specifies one or multiple alternate servers for failover and is required for all failover methods. To turn off failover, do not specify a value for the AlternateServers property.