We are discussing the implementation of HA for a software that runs on SQL 2008 R2. Our preferred HA option is Database Mirroring but, unfortunately the vendor currently does not support automatic redirect of the application to a new host name so mirroring may not work. The vendors preferred HA option is Clustering but, we are not a cluster shop. We want this db server to be physical only and the max size would be around 250 GB and is a mission critical system.
Can you guys please suggest any other alternatives to clustering? If not, what are the questions I need to ask the vendor so we come up with the best configuration for this HA setup. Really not against Clusters so if we have to we will go for it, but not without checking our options.
Thanks a lot for your help in advance.
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."