High availability group

Question

Hi Expert,

Can you help me in explaining about High availability group in sql server database and how to find it and how it will affect to mirroring in database from sql server 2008 to sql server 2016. Any query that we can find high availability group. Wants create a study case

Shree

Answer 1

Hi @Shri ,

High availability group in sql server database.

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to eight sets of corresponding secondary databases. Please refer to What is an Always On availability group for more details.

how to find it.

Please try this:

select name as AGName   
from sys.availability_groups_cluster  

Here is an article which might help.

how it will affect to mirroring in database from sql server 2008 to sql server 2016.

Do you mean combining database mirroring with Always On availability groups?
The Always On availability groups feature is an enterprise-level alternative to database mirroring.
Database mirroring cannot interoperate with Always On availability group.

If you have any question, please feel free to let us know.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November