March 25, 2021 at 11:43 am
A long-serving DBA is leaving us soon, and his account is the owner of various bits and pieces within one of our AGs.
Not ideal, but one of those things from when the company originally set the system up, many years ago, and has never been addressed.
We're quite happy with the code that we have, to change the Listener endpoint owner and the AG owner. The question we have, is do we need to run the change on every node of the AG, or is it just on the Primary node?
All example of what we're after always execute against 'Master', which is why I have the question, as Master isn't part of the AG.
March 25, 2021 at 2:45 pm
Maybe. He may be the owner on one node, and not on the other. I've had that situation.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply