We have 2 SQL Servers in Azure, sqlServer1 and sqlServer2.
We have more than 50 databases running on them. sqlServer1 isn’t always where the Primary database is, sometimes it is sqlServer2 that is primary.
When something breaks I need to fix it fast. In our customer’s table, we track which SQL Server they have as their primary database. I have to query that each time to figure out the Primary one or my changes will fail due to it being secondary (read only).
When I open Toad, I have to choose Server1 or Server2 from the Connection Manager. I have to flip back and forth between these connections.
Is there a way to open a Toad Connection and only see the Primary databases?
I am rather new to all of this, please ask me any questions in case I didn’t come across well.
Thank you for the help on this.