I need 2 SQL Failover clusters:
- Core Database Cluster: this contains all of my core application databases
- Analytic Database Cluster: this contains my web analytic database
Now, I only have 2 physical servers (DB1 and DB2) connected to a SAN. How to deploy two SQL Failover Clusters in my current database servers?
I assume that DB1 is set as the primary node for my Core Database Cluster and secondary node for the Analytics Database Cluster. And DB2 is set as the primary node for my Analytics Database Cluster and secondary node for the Core Database Cluster.
Is this the right way?