Just wanted to know if MSSQL supports Active/Active mode without needing to manually change anything to switch the database instance. We have a requirement to setup mssql which supports Active/Active with automatic failover.
Is it correct way to use the name Active/Active incase if a node fails and other instance take over the request? I am bit confused with the term Active/Active. Should it be necessary to have loadbalancing capability to call it as Active/Active?