SQLTeam.com | Weblogs | Forums

SQL Failover Cluster

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.

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).