High availability group

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