Share via

Add node as Azure VM on on-premise SQL FCI

kim Armode 1 Reputation point
2022-10-17T07:27:57.507+00:00

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?

Thanks!

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,856 Reputation points
    2022-10-17T09:13:03.557+00:00

    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