Written By: Guy Yaakobovich 09/03/2018
One day, your Availability Group cluster can get into a critical state in a way that forces your team to create the Availability Group from scratch.
The following scripts can save you’re A$$ and for sure, save a lot of time.
Always be ready!
All you need to do is to fill in the appropriate places your objects names, IP, backup path etc. (Use the checklist – 00)
Notice that the scripts create the Availability Group and not the Windows Cluster. That needs to be already set up and must include all the Cluster Resources based on your environment (quorum, file share, network, servers). It’s also a good idea to first take a backup of the cluster configuration, using the windows backup feature.
The following steps and AlwaysOnScripts will create the Availability Group from scratch:
Now we’ll all be AlwaysOn.