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
https://www.mssqltips.com/sqlservertip/3489/configure-sql-server-alerts-and-notifications-for-alwayson-availability-groups/
and you can add these alerts as a execute condition of agent job which includes failover scripts of other ag groups.