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.
enable_always_on_step_14
Select Full and browse to the UNC path where you want to place the temp backup of the DB. Click Next
enable_always_on_step_15
A Validation runs. If there are no errors, click Next
enable_always_on_step_16
Here you can export the script. If you want multiple Availability groups, it might just be quicker to script the process. Click Next

enable_always_on_step_17
Once that has completed. Click Close.
enable_always_on_step_18
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 *

*
*