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


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

Math Tec

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


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

<div>
There are tons. Use your Google fu. I gave you the name of the technology. It should be very easy from there. ;-)<br />
<br />
You do need SQL 2012 Standard or later.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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 &nbsp;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. <br />
<br />
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<br />
<br />
Thank you in advance
</div>
</div>


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

Failover SQL with 2 storage devices

Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media used to retain digital data. In addition to local storage devices like CD and DVD readers, hard drives and flash drives, solid state drives can hold enormous amounts of data in a very small device. Cloud services and other new forms of remote storage also add to the capacity of devices and their ability to access more data without building additional data storage into a device.

Storage

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.