Failover SQL with 2 storage devices

Hi,

I am not an expert and I need help. I have two cluster SQL server each server has 4 Fiber Connection (FC) and I have two HP P2000 storage as shared device with two controllers each controller has two FC. The design now is from each server there is 4 FC. Two of them connected to the first storage (one for each controller) and another 2 for second storage.

The storage has RAID1. However, if the storage goes down then the SQL will stop working. My question is there anyway that I can make the two storage to work as backup for each other (Redundancy). So, if storage one goes down then the second storage will be available and there will be no interrupted for SQL

Thank you in advance

StorageMicrosoft SQL Server* Clustering* Failover Cluster* Failover

Last Comment

kevinhsieh

8/22/2022 - Mon

kevinhsieh

1/6/2019

SQL Always On Availability Groups doesn't need any shared storage. It is the standard way to do SQL high availability now.

ASKER CERTIFIED SOLUTION

kevinhsieh

1/6/2019

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Math Tec

1/6/2019

ASKER

Thank you so much. Is there any links for the way to do the configuration?

kevinhsieh

1/6/2019

There are tons. Use your Google fu. I gave you the name of the technology. It should be very easy from there. ;-)

You do need SQL 2012 Standard or later.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes