- 1. Intro
- 2. Creating the Load Balancer
- 3. AD Delegated Permissions
- 4. Windows Failover Cluster
- 5. Configuring the Nodes - Security
- 6. Configuring the Nodes - Shared Location
- 7. AlwaysOn Configuration - Enable AlwaysOn
- 8. AlwaysOn Configuration - Initial Creation
- 9. AlwaysOn Configuration - Initial Creation - Full
- 10. AlwaysOn Configuration - Initial Creation - Join
- 11. AlwaysOn Configuration - Initial Creation - Skip
- 12. Adding the Listener
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.
ALTER AVAILABILITY GROUP [SQL-CLUSTER-ag-01]
ADD DATABASE [Test_AlwaysON_AG_DB-Skip];
Now we need to restore the database manually on each secondary node
Right click Databases > Restore Database
Click Device and the browse button.
Add the UNC path for the filename. 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.