I've been tasked with restoring a backup of a prod db to a shell db on another instance.
The shell database on the new instance is currently synchronized. From doing some research I found out that I have to take the database out of high availability before I can do a restore on both primary and secondary replicas, and then put them back in high availability again.
I have access to the shell db(primary replica) and from that instance I can see the listener, I do not know exactly how to get the name of the secondary instance so I can pull it up.. and I'm confused about how to find the secondary instance so that I can also be able to do a restore on there before adding them both back to the AG.
should I have been provided the information about where to find the secondary database(instance) or I'm expected to know how to find that myself. If so, how?