2

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup.

I currently have an Active-Passive-Witness SQL 2008R2 setup where each of the machines in the setup have plain old DAS raid arrays.

I would like to implement exactly the same again with SQL Server 2012, however much of the online documentation (e.g. Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server) - http://msdn.microsoft.com/en-us/library/ff878487.aspx) suggests each node in the "AlwaysOn Availability Group" must be a node of a Windows Server Failover Clustering (WSFC) cluster.

I'm not trying to set up a SQL Server Failover Cluster - only database mirroring between two instances of SQL Server (active-passive-witness).

When I look up the requirements for setting up a Windows Server Failover Clustering (WSFC) cluster I always see SAN / shared storage as a requirement.

However I have seen a pretty definitive answer to my question here: "AlwaysOn Availability Groups do not require deployment of a Failover Cluster Instance or use of symmetric shared storage (SAN or SMB)." - http://msdn.microsoft.com/en-us/library/hh270278.aspx - but am unsure what to believe.

Has anybody out there tried an Active-Passive-Witness mirroring setup with SQL Server 2012 and "AlwaysOn Availability Groups" where you didn't need to use SAN / shared storage?

Many thanks,

Kenny

Improve this question

1 Answer 1

Reset to default
2

Database mirroring (DBM) and availability groups (AG) are two different features. DBM is deprecated in SQL Server 2012 and availability groups are new. AGs can be configured on standalone instances that are insalled on WSFC (Windows Server Failover Clustering) nodes. There is no witness with AGs, and even with DBM, a witness was only required in high safety mode with

There are quite a few people who have deployed AGs.You shouldn't be using DBM at this point, and you should never use DBM + FCI (Failover Cluster Instance) in high safety.

Also, please stop using active/passive. It's wrong for FCI, and definitely not even remotely applicable for AGs or DBM. http://www.sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive

Improve this answer
1
  • 1
    What does your acronym FCI stand for please?
    – Kenny
    Apr 19, 2013 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.