Is MS SQL server clustering capable of performing a seamless fail over between nodes? That is, where the clients wouldn't notice anything had changed except perhaps a short delay during the transition.
Sql-server – Windows SQL Server Cluster Failover Without Disruption
clusterfailoversql serverwindows-cluster
Best Answer
only way i know of achieving this is with the use of hyper-v and using 'live migration'. This allows for 'stateful' failover of having the virtual machine transition from one physical node to another. You will need to use this in conjunction with over HA options as you'll still get down-time when you need to patch the OS of your VM. Database mirroring may be a good candidate, but this is not 100% transparent in fail-over.