none
SQL Server Failover Cluster Instances in a replica set cannot be configured for automatic failover RRS feed

  • Question

  • When the secondary replica instance is a windows clustered instance, why it's not supported automatic failover ?
    Monday, August 19, 2019 4:50 PM

Answers

All replies

  • SQL Server Availability groups sits onto of Windows Clustering services. There is nothing shared, other than the windows cluster name in the windows clustered instance. You will need to configure that AG you build for automatic or manual failover.

    If you are talking about the primary being a stand alone SQL Server, and the secondary being on a failover clustered instance, this is a limitation of an Availability group in the hybrid topology you have created. Another limitation is the ability to only create one AG.

    Monday, August 19, 2019 5:25 PM
  • Hi sakurai_db,

    From your description, if you configured SQL server AG, deploying Always On availability groups requires a Windows Server Failover Cluster (WSFC). To be enabled for Always On availability groups, an instance of SQL Server must reside on a WSFC node, and the WSFC and node must be online. For the failover mode of an availability replica, you need to configure it manually. Please refer to Change the failover mode for a replica within an Always On availability group to get more information.

    If you combine SQL Server Failover Cluster Instances (FCIs) with Availability Groups, SQL Server Failover Cluster Instances (FCIs) do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can only be configured for manual failover.
    Please refer to Failover Clustering and Always On Availability Groups (SQL Server) to get more information.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, August 20, 2019 6:02 AM
  • so it's by design without any reasons ?
    Wednesday, August 21, 2019 1:49 AM
  • so it's by design without any reasons ?
    Hi sakurai_db,

    >> so it's by design without any reasons ?

    Yes ,we can get this from MS official document, please refer to Prerequisites and Restrictions for Using a SQL Server Failover Cluster Instance (FCI) to Host an Availability Replica.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, August 21, 2019 3:00 AM