I located an extremely helpful process outlined in the thread below, but needed some clarification. This may be a silly question, but I'm a bit new to Availability Groups. In the steps outlined in the thread's answer, is it true that after restoring, you only have to add the newly restored database into the secondary? Will it appear back into the primary automatically? Thank you for any assistance!
Sql-server – Restoring a Database in an Availability Group
availability-groupshigh-availabilitysql server
Related Question
- SQL Server – Understanding High Availability and Always On
- SQL Server – Performance of Multiple Basic Availability Groups
- SQL Server 2014 HADR – Who is Using My Worker Threads?
- AlwaysOn High Availability Take database offline from primary
- Sql-server – How to implement High Availability for all nodes in a sharded database
Best Answer
Yes, you need to populate databases on secondary nodes in an availability group yourself, they do not appear "automatically". The full documentation is found on MSDN, with multiple ways to execute. The short version is:
ALTER DATABASE [foo] SET HADR AVAILABILITY GROUP = [bar];