Hi @Aiman Kreidly ,
Here is a document about What is an Always On availability group: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15
After reading this, you may have a better understanding about AG.
Also read this document about options of configuring access on an availability replica: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-access-on-an-availability-replica-sql-server?view=sql-server-ver15#SSMSProcedure
AlwaysOn can support up to five replicas, but only the database running on one availability copy is in a read-write state. The database on the secondary copy may be inaccessible or may only accept read-only operations, depending on the configuration of the availability group. In the event of a failover, any of the secondary replicas can become a new instance of the primary replica. The primary replica continuously sends data changes on the primary database to the secondary replica to synchronize the database between replicas.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.