Install and configure SQL AlwaysON AG with Listener on Azure

AlwaysOn Configuration - Initial Creation - Full

This can be FullJoin Only or Skip initial data synchronisation. The processes are documented below.
Select Full and browse to the UNC path where you want to place the temp backup of the DB. Click Next
A Validation runs. If there are no errors, click Next
Here you can export the script. If you want multiple Availability groups, it might just be quicker to script the process. Click Next

Once that has completed. Click Close.
The databases now reside on both all nodes and display (Synchronized)

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *