0

We have patching on servers running SQL Server 2014. Good thing we have always on availability group. Bad thing, they are patching Primary Server first. Trying to understand how this is going to work. 1) Primary gets patched, DBs fail over to Secondary automatically. 2) Assuming all goes well, Primary will come back up and becomes secondary,
DBS get back in Sync. 3) Next day, they patch secondary (which is at this point primary) and another fail over happens and roles change.

Does it sound correct?

1 Answer 1

2

No, this is backwards.

Typically, you wanna patch the secondary, let that sit around for a few days, then fail over to it manually.

Once things are up and running there, run some smoke tests. If all those pass, patch the primary, and fail back during your next maintenance window.

"Primary gets patched, DBs fail over to Secondary automatically"

You don't have a dev environment to test this stuff on, huh?

2
  • Ya, unfortunately, these guys have a very bad way of patching their servers. I fought hard to do it the way you mentioned but they will just not listen.
    – Rohit
    Commented Oct 20, 2017 at 20:09
  • @jacky okay, so what's your question? Commented Oct 20, 2017 at 20:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.