Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

3 Answers 3

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.

share|improve this answer

High availability mirroring, where you have a 3 server setup, with a principal, mirror and a witness is most of the time a very fast failover, however, as Paul Randal blogged recently, that is not guaranteed to be the case. See this post and (can't post the other one, not enough rep). There is no absolute 100% seamless failover, but on the SQL Server level, mirroring is your best bet since it only fails transactions in progress and clients automatically connect to the other node. As Nick said, running on VM and using live migration is likely your best bet for HA, but does not allow for much flexibility in changing configuration of your environment, f.ex changes to your OS.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.