Can this be done without dropping connections to the database?
(1) Remove prod database from AG ( easy enough to do )
(2) Do upgrade on database ( need to keep it accessible via Listener )
(3) Add database back into AG on Primary
My concern was that as its a busy & critical database I'm being pressured to follow this method, but am concerned that it may cause transactions to drop etc. My preference is an outage but no one wants to do that.....( business vs techs argument, as always )
Any help appreciated.