Hi folks. I’m working
on a new assignment and have been Googling, searching, looking, etc. for a
while and not coming up with too much helpful information.
I’m working on building out a Server 2012 R2 failover
cluster with a total of 3 nodes – 2 at the prod site, 1 at a DR site.
They are to support SQL 2012.
We want to have High Availability (HA) and DR but only HA at
the 2 node main site with a manual failover to the DR for DR testing or an
actual DR scenario.
What I’ve read seems to indicate that we should use a
multi-site cluster on the OS level and set the DR node to not vote so it can’t
become active unless we do a manual failover. We want to allow the DBA to
build out Availability Groups in SQL for their
requirements, but again we don’t ever want the DR site to become active unless
we tell it and do manual changes to bring it up using current SQL data.
Has anyone worked on this who may have some insight ?
Thanks,
Don K
