Thanks for repling , what are the reasons for this error ?

Yes ..

yes the command is used to failover for single db , I need a query to generate the script for individual db's

Thanks for the reply, apart of the dashboard is any DMV's to trouble the Always on

based on your issue which u said please send us the resolution ?

I don't have experience on HAG

thanks for the info how you resolved this issue ,it is helpful to send me the procedure in resolving this issue

we got alert

Availability Group is not ready for automatic failover while it is configured to failover automatically in one of the server .

iam not sure how to solve...

I will search ....

Thanks for the response I know in system health the info is stored , can you provide the query to retrieve the information in system health

Thanks

thanks for the reply How to check in monitor and is any query to run in the pub\subscriber to validate ?

mark it as solved

and also the reporting databases are not created in databas engine . The reporting services are runing successfully .

Can any one help on this?

is the information provided by executing the query is right ? because i found connections are existing on the datbase which i need to prepare the report .as per the...

thanks for providing the query i need to know what is status 9 mean when i execute the query?