Authors: Joseph Sack (SQLskills.com), Sanjay Mishra (Microsoft)
Technical Reviewers: Min He (Microsoft), Chuck Heinzelman (Microsoft), Alexi Khalyako (Microsoft), Charles Mathews (Microsoft), Prem Mehra (Microsoft) , Juergen Thomas (Microsoft), Mike Weiner (Microsoft), Amitabh Tamhane (Microsoft), Brent Ozar (Brent Ozar PLF), Gianluca Hotz (SolidQ), David P. Smith (ServiceU), Michael Steineke (Edgenet), Glenn Berry (SQLskills.com)
Content Program Manager: Glenn Minch (Microsoft)
Summary: SQL Server 2012 AlwaysOn Failover Cluster Instances (FCI) and AlwaysOn Availability Groups provide a comprehensive high availability and disaster recovery solution. Prior to SQL Server 2012, many customers used FCIs to provide local high availability within a data center and database mirroring for disaster recovery to a remote data center. With SQL Server 2012, this design pattern can be replaced with an architecture that uses FCIs for high availability and availability groups for disaster recovery business requirements. Availability groups leverage Windows Server Failover Clustering (WSFC) functionality and enable multiple features not available in database mirroring. This paper details the key topology requirements of this specific design pattern, including asymmetric storage considerations, quorum model selection, quorum votes, steps required to build the environment, and a workflow illustrating how to handle a disaster recovery event in the new topology across participating job roles.
Hi, I set up a demo envirnment. If I set the nodes from DR site do not vote, then the crash of Primary site will cause the WSFC stopped at DR site. How to solve this problem?
I have solved this problem. Thanks
HA with FCI's make for a very powerful solution!
I have one question on this Architecture. I am going to build the three node cluster. Right now one node is completely ready for SQL install. Windows Team is working on building the windows cluster. Can I join the node to the cluster after SQL install for AG?
Thank you so much for the article.
I am planning to configure a dedicated NIC for SQL 2012 Always On AG traffic (database mirroring) . My Primary server is Fail over cluster Instance and secondary server is stand alone SQL instance (FCI for HA + AG for DR) How to configure Dedicated NIC for Always On AG traffic (database mirroring) in FCI for HA + AG for DR topology?
Please guide me