Add node as Azure VM on on-premise SQL FCI

kim Armode 1 Reputation point

Hi, All

FCI is currently configured in an on-premise SQL Server environment.
In this case, I want to add additioal read-only node, can I configure the node I add as Azure VMs? Can you give me a link to the document that contains how to do it?


Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Bjoern Peters 8,856 Reputation points

    Your question is a little bit "weird"... You can not add a read-only node to an FCI

    FCI = Failover Cluster, only one node is active. This one node can only handle read/write access.

    Maybe you are talking about an Availability Group, there you have read-only nodes (readable secondaries)

    If you just have an FCI, then one option might be "Log-Shipping" into Azure or "Replication"

    If you have an AOAG, then it depends on the network (latency) and the SQL configuration.

    0 comments No comments