Install and configure SQL AlwaysON AG with Listener on Azure

AlwaysOn Configuration - Initial Creation - Skip


enable_always_on_step_40
Right click the Availability group previously created. Click on Add Database
enable_always_on_step_41
Select the database you restored. Click Next
enable_always_on_step_42
Select Skip initial data synchronisation and click Next
enable_always_on_step_43
Here you can export the script. If you want multiple Availability groups, it might just be quicker to script the process. Click Next

--- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.
:Connect SQL-NODE-A

USE [master]

GO

ALTER AVAILABILITY GROUP [SQL-CLUSTER-ag-01]
ADD DATABASE [Test_AlwaysON_AG_DB-Skip];

GO


GO

enable_always_on_step_44
Once that has completed. Click Close.

Now we need to restore the database manually on each secondary node
enable_always_on_step_45
Right click Databases > Restore Database
enable_always_on_step_46
Click Device and the browse button.
enable_always_on_step_47
Click Add
enable_always_on_step_48
Add the UNC path for the filename. Click OK
enable_always_on_step_49
Click OK
enable_always_on_step_50
Click on Options and make sure RESTORE WITH NORECOVERY has been selected as the Recovery State
enable_always_on_step_51
Click on OK to restore. Click on OK to complete.
enable_always_on_step_52
Now we need to join the database to the Availability group, Right click the Availability Group and select Join to Availability Group
enable_always_on_step_53
Click OK. This screen will automatically close when done.
enable_always_on_step_54
All databases added and synchronised.

Leave a Reply

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

*
*