SQL Failover Cluster

High Availability
1

First sorry for my English, I am French speaking :slightly_smiling_face:

I've searched and did not found any information on how to do this.

Let me explain (see file attached)

I know how to setup an SQL failover cluster, did it and it works perfectly.

Here is my situation : Node1 and Storage A is in one location (city) and Node 2 and Storage B is in a second location (different city).

Node 1 and Node 2 are connected to Storage A and Failover works perfectly.

NOW here is the catch.

How to setup so that if Storage A fails and I want to failover to Storage B.

I am wandering if its even possible since I have not found a single example on the net.

Thanks you all.

image
image1280×1002 81 KB

2

SQL Server clustering is based on shared storage. That is, the drives where the SQL data is located are shared by both nodes. You'd need something completely different to have a failover use different storage, such as, for example, perhaps AGs (availability groups).