I have deployed SQL Server 2008 R2 in main branch and 3 other branches with Replication (Transactional Replication with Updatable Subscriptions).
Now i am looking for High availability in the 4 locations. Please advice what is the best scenario to do so in all locations. Is it mirroring? or clustering? Now we have 2 nodes in each branch for HA. Need to know what is the easiest to manage and easiest
to implement. I have concerns about clustering regarding management and administration as it seems complicated.
Your response is highly appreciated.
View Complete Post