We help IT Professionals succeed at work.

MS SQL Standard HA/Clustering Guides

Hi,

I'm looking for simple ABC guides at setting up Microsoft SQL 2014 Standard Clustering with two nodes, Active/Active and Active/Passive. Anyone run into this - rather not at this stage have to dig through tomes of microsoft articles on random aspects of clustering but rather, A-B-C and then later I can start to break it down to understand all of the other possibilities...

Thanks.
Comment
Watch Question

Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
You already have a Windows cluster machines?
Senior Data Architect
Commented:
Here's my favorite walk-through for creating a two-node SQL Server cluster:

https://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

It uses Windows and MSSQL 2008, but the steps should still be valid with current versions.

Also, I've done an article that attempts to clarify some cluster terminology that normally causes confusion:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/A_11134-Shedding-some-light-on-Windows-clustering-terminology.html

If there's something different you're looking for, please clarify and I can provide some additional detail.

Author

Commented:
Hi Ryan,

Thanks. I'll let you know if I have any other questions.