Forum Discussion
Can we create multiple database in SQL server standard always on
Can we create multiple database in SQL server standard always on ?
Thanks mcdasa with your response.
My application is using at a time 3 db and if i do failover for one Ag that time my application will not be start automatically in failover because one AG contain one db and i have created three AG for 3 DB due to standard version of SQL.
My application is using at a time 3 db and if i do failover for one Ag that time my application will not be start automatically in failover because one AG contain one db and i have created three AG for 3 DB due to standard version of SQL.
what i am saying is that trigger other ag groups(not ag group contains listener) to failover through SQL Server Agent Job.
Here is the article about adding alert where HA events occured
Configure SQL Server Alerts and Notifications for AlwaysOn Availability Groups (mssqltips.com)
and you can add these alerts as a execute condition of agent job which includes failover scripts of other ag groups.