January 9, 2019 at 9:15 am
Hi,
I have 3 Windows Failover Cluster nodes in a cluster. Node1 and Node2 is in the same data center and the node3 is on a different data center. Node1 will be active and node2 is passive in this setup.
I need to install 2 SQL Server Failover instances in Node1 for HA solutions along with the Availability Group setup on Node3 for both instances for DR purposes.
Are there any restrictions from Microsoft that there cannot be more than 1 instance installed on the same node coupled with AG Enabled? Did anyone encountered this scenario with problems?
Node1 (Active)
SQLInstance1
SQLInstance2
Node2 (Passive)
Node3 (Standalone SQL Server install no Failover SQL Install for AG Replica)
SQLDR1
SQLDR2
Thanks,
LGDBA
January 11, 2019 at 9:22 am
I think you have terminology that looks funny. The Failover Clustered Instance (FCI) is the Windows install. You have that.
The SQL Server is a default or named instance, which has an Availability Group setup for HA for the database. You can have multiple named instances of SQL Server on a Windows FCI.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply