How to always deploy on primary server in AG group or switch secondary to primary

We are trying to configure our deployment to deploy always on a primary server from AG group, if not have to do manual failover in SQL server to switch the secondary to primary server. Can that be configured in Octopus or run a powershell/sql script?

Hi sai.tra3

Thanks for reaching out. If I understand correctly what you are trying to do is deploy to the primary SQL box which would replicate to all secondary DBs. What you could do is use what we call a “Jump Box”. This is basically a primary server which will replicate to the rest of the servers.

Here is a guide on how to use jump boxes, to solve your issue.

Hopefully this will get you on the right path, but please let me know if you need more help or if you have further questions.



This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.