• you are also specifying the same replicas secondary role twice, so be careful with that too.

    I can see from the query results that luckily QA-DB-DATA2-1A is set to accept readonly connections as a secondary anyway, so this hasn't caused you an issue.

    However, had it been set to not allow connections and you were relying on the script to change this you would then face an issue

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉