I have three servers. Primary, Mirroring, and Witness.
I stop the Primary to see if the Mirroring becomes the Primary and it did but it is disconnected not synchronize.
How can I switch back? the failover button is not active. I went to the properties of the database and I click on Mirroring.