Two SQL Failover Clusters in two-node failover servers
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?
Thanks!
No comments:
Post a Comment