This script has been copied to Github here.


There are 2 scripts and this one is the part 2 of 2 scripts

This is required to be executed after the restart of the server.

This script will move all the role and DBs back from Node 2 to Node1. 

This script will also resume the cluster node.

This script alone might not be so useful as it will be with Pre-Patching script.


Reference Blog:


Prabhat Nigam

Microsoft MVP | CTO @ Golden Five



-Update 1 for the users
If you replace the Read-host with the servername then make sure to give server name and DAGname in "".