March 27, 2013 at 10:10 am
Hi distinguished SQL persons,
I have a need to cluster two physical SQL servers to achieve some form of HA. The tricky part is that these servers are already live and there is not any alternative tin to put them onto (the HA was an afterthought, as always). I am aware that you can not make an existing SQL instance into a cluster but I was wondering about anyone's experience with this, so all comments are welcome.
My idea is to create two new instances on each of the servers to facilitate a side-by-side upgrade on the same servers. This would mean that if it all goes belly up I can revert to the default instance. One new instance would be the new active node for that server and the second would be the inactive node, so they would effectively fail over onto a single server in critical failure scenario, running at a potentially reduced capacity (not an issue, as servers are highly spec'd). Both servers have 1000+db's residing on them.
Has anyone ever tried this? Do you know it's not possible? If so let me know your experiences.
Much obliged
E
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply