Our prod server is down. I was applying a security patch on our secondary server. After failing it over to the secondary server from primary, it goes out of sync. There is only 1 DB. The DB is not primary on any AG. I am not sure where to look for and what to do at the moment. Desperate situation.
I am even trying to remove the DB from AG, recover it and join it back to AG. But I can't even remove it from AG. DB1 was the primary, DB2 is now the primary. I tried removing it from GUI as well as thru SQL script but no luck.