How to configure Always On Availability Groups in SQL Server
--Always On Availability Groups
--1. Install Failover cluster manager in all the replicas
--2. Enable Always On availability Group feature in SQL Server Configuration Manager(All nodes)
--3. Create Always On Availability Group
--4. Add databases to AG Group
--5. Select Availability Mode
--6. Select Automatic Failover
--7. Configure Readable secondary
--8. Configure Backup Preference
--9. Read Only routing list
--10. Listener Configuration
--TO ADD THE DATABASETO AG
--1. database should be in full recovery model
--2. Atleaset one full backup required
--3. the database should not be a part of mirroring
--4. should not be a part of any other AG group.
--there is no specific limit to add databses to AG
--You can select upto 8 asyncronous.
--you can select upto 5 synchronous -2016 version.
--readable secondary
No
Yes
read intent only
--automatic seeding introduced in 2016
--data file and log file path should be same in the primary and secondary replicas
--Listenter configuration is optional
--