Need to ensure OLTP Database that uses a SAN remains available if any of the servers fail, need to minimize the amount of storage used

Here is a question about MS SQL Server administration.

I Need to ensure OLTP Database that uses a SAN (Storage Area Network) remains available if any of the servers fail, I need to minimize the amount of storage used by the database. Which configuration should you use?

The correct answer is

>>

Two servers configured in a Windows Failover Cluster in the same data center. SQL Server configured as a clustered instance.

<<

I can't figure out why using Windows Failover Cluster would result minimized storage usage.

September 15th, 2015 2:54am
Because you only have one copy of the data. AG mirrors the database, so you have two copies of the data (-base files).
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 3:14am

I can't figure out why using Windows Failover Cluster would result minimized storage usage.

The fact that cluster uses shared storage and provides OS redundancy ( not sql server redundancy) minimizes storage cost
September 15th, 2015 3:22am
Awesome !!
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 3:35am
Other recent topics Other recent topics