Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mancio
Regular Visitor

Data gateway - Change Primary

Hello,

I'm using one gateway cluster with a two gateway that working in fail-over mode.

Gateway Cluster:

- Gateway A (primary)

- Gateway B (fail-over secondary)

now I need to set Gateway B as primary and delete Gateway A.


is there a powershell command to set Gateway B as primary?

What is the correct procedure to follow?


Thanks

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Why delete A?  You will want to keep your failover setup.

 

The choreography is as follows:

 

- Have your recovery key handy. Nothing will work without that.

- Delete B from the cluster

- Register B as a replacement Primary in the cluster, kicking out A. 

- Add the now orphaned A back into the cluster as a secondary gateway

 

You will not want to do this via Powershell.

View solution in original post

7 REPLIES 7
mancio
Regular Visitor

Hi,

Gateway A is dead, I need to promote Gateway B to primary.

I have the recovery key.

What is the correct procedure?

 

Thanks

 

Log in to the management app on B.  Specify "Take over". Select the Primary.  Provide the Recovery key.

 

When successful B will be the new anchor and A will be orphaned.

Hi Ibendlin,

if I understand correctly the steps to take are:

remove node B from the cluster
uninstall the DataGateway from server B
rerun the DataGateway setup on server B and perform the takeover

is this correct?


Thanks you

no need to remove B from the cluster first  (but it also doesn't hurt if you do).

lbendlin
Super User
Super User

Why delete A?  You will want to keep your failover setup.

 

The choreography is as follows:

 

- Have your recovery key handy. Nothing will work without that.

- Delete B from the cluster

- Register B as a replacement Primary in the cluster, kicking out A. 

- Add the now orphaned A back into the cluster as a secondary gateway

 

You will not want to do this via Powershell.

Anonymous
Not applicable

do you mean as activity complets for takeover of primary gateway over B, we will see as follows:

- Gateway A (fail-over secondary)

- Gateway B (primary)

There's no failover. All cluster members share the load if you specify it with the checkbox. Primary/Anchor is purely cosmetic.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors