Adding live database to AG

  • 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.

  • What upgrade do you propose to do on the database, and why does that upgrade require the database to be removed from the AG?  If the database isn't in the AG, you can't keep it available through the listener.


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply