Video: How To Simplify Installation and Configuration of a 2-node Multi-Subnet/Geographically Dispersed SQL Server (2012 and higher) Failover Clustered Instance

In a previous blog post, I’ve demonstrated how to install and configure a 2-node SQL Server 2012 failover clustered instance (FCI.) As a follow-up, below is a video on how to install and configure a multi-subnet/geographically dispersed SQL Server 2012 (and higher) FCI. When SQL Server 2012 introduced the support for multi-subnet clustering, there have been a lot of design architectures that involved its implementation – ranging from pure FCIs with multiple nodes for both HA and DR to a combination of  FCI and Availability Groups (AG) solution.

In this video, we will build a 2-node SQL Server failover clustered instance that spans across multiple geographical locations. We will also look at the different network configurations and considerations when implementing such a solution. The network configuration apply whether you are implementing an FCI or an AG. The reference architecture is available on this article that I’ve written way back in 2012. Feel free to reach out if you have questions regarding the video.


Want to learn more about Windows Server Failover Clustering for your SQL Server databases?

I’m excited to open the registration for my latest online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA course.

Head on over to the main site. Registration for this course will only be available until 7-August-2016 10:00 PM Eastern time. After that, you will have to wait for January 2017 to get in.

As part of the registration, you’ll get these additional bonuses.

  • Introductory price on the course
  • FREE access to my upcoming mini-course How To Build a Personal Lab for Testing Windows Server Failover Clustering (course priced at US$ 69)
  • FREE access to my upcoming online course Design and Implement SQL Server HA/DR Hybrid Solutions with Microsoft Azure (course priced at US$ 329)
  • FREE access to my Udemy course SQL Server high Availability and Disaster Recovery Deep Dive (course originally priced at US$ 315)

A total value worth US$ 1,887

Don’t miss this limited time opportunity. Head on over to the main page and get your registration.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.