Hi @Veena Srinivas ,
Yes, you can. An availability replica can be hosted by an FCI instance.
Deploying Always On availability groups requires a Windows Server Failover Cluster. And you can set up a second layer of failover at the server-instance level by implementing SQL Server an FCI together with the WSFC.
And there are some restrictions for using a SQL Server Failover Cluster Instance to host an availability replica:
- The cluster nodes of an FCI can host only one replica for a given availability group. If you add an availability replica on an FCI, the WSFC nodes that are possible FCI owners cannot host another replica for the same availability group. Furthermore, every other replica must be hosted by an instance of SQL Server that resides on a different cluster node in the same Windows Server failover cluster.
- FCIs do not support automatic failover by availability groups: FCIs do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can be configured for manual failover only.
- Changing FCI network name: If you need to change the network name of an FCI that hosts an availability replica, you will need to remove the replica from its availability group and then add the replica back into the availability group.
Please refer to SQL Server Failover Cluster Instances (FCIs) and Availability Groups and Considerations for hosting an Availability Replica on an FCI for more details.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.