Install and configure SQL AlwaysON AG with Listener on Azure

AlwaysOn Configuration - Initial Creation - Skip

Right click the Availability group previously created. Click on Add Database

Select the database you restored. Click Next

Select Skip initial data synchronisation and 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

--- 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

Once that has completed. Click Close.

Now we need to restore the database manually on each secondary node

Right click Databases > Restore Database

Click Device and the browse button.

Click Add

Add the UNC path for the filename. Click OK

Click OK

Click on Options and make sure RESTORE WITH NORECOVERY has been selected as the Recovery State

Click on OK to restore. Click on OK to complete.

Now we need to join the database to the Availability group, Right click the Availability Group and select Join to Availability Group

Click OK. This screen will automatically close when done.

All databases added and synchronised.