Can we create multiple database in SQL server standard always on

Question

Can we create multiple database in SQL server standard always on ?

mcdasa · Answer

Yes, of course you can.but one thing you need to remember is that you can only make 1 database in 1 ag groupyou n databases need n ag group. additionally you need to implement trigger these ag groups automatically when failover event occured.

itcops1979 · Answer

wWhat is the means of triggers, is it like that for multiple db i have to create multi AG then i have to stablish trigger between all AG incase of failovermcdasa&nbsp;

mcdasa · Answer

your sql-server could do failover automatically for one ag group.
41074 is an event id of which failover event is occured in sql server.
So you make agent job and add alert(trigger) for eventid 41074
also add "ALTER AVAILABILITY GROUP [your_other_ag_group] FAILOVER'" for that job.

i hope this will help you.
you can google it with following keyword "41074","sql server","ag", "failover"

itcops1979 · Answer

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.

mcdasa · Answer

itcops1979&nbsp;what i am saying is that trigger other ag groups(not ag group contains listener) to failover through SQL Server Agent Job.&nbsp;Here is the article about adding alert where HA events occuredhttps://www.mssqltips.com/sqlservertip/3489/configure-sql-server-alerts-and-notifications-for-alwayson-availability-groups/&nbsp;and you can add these alerts as a execute condition of agent job which includes failover scripts of other ag groups.&nbsp;&nbsp;&nbsp;

Forum Discussion

Can we create multiple database in SQL server standard always on

5 Replies

Resources