none
Geocluster SQL 2008: 2 nodes + 1 Witness (3 datacenters)

    Question

  • Cluster: Windows 2008 R2 + SQL2008 R2.
    3 Datacenters. 1 datacenter (Site3) is used to Witness. Replication exists beetween other datacenters (Site1, Site2).
    Site 1 has 2 SQL Server nodes. Site 1 has 2 SQL Server nodes. All instances are actives on a Site (Site1 or Site2)

    What would happen in these situations? (All SQL Instances are actives on Site1)

    1) Site1 loses communication with Site3
    2) Site1 loses communication with Site3 and Site 2
    3) Site3 loses communication with Site2
    4) Site1 fail and Site 2 loses communication with Site3
    5) In this case of have a cluster with only 2 votes (for example nodes on site1), How could I start the clúster? Situation2)

    Saturday, October 29, 2011 12:45 PM

Answers

All replies