July 27, 2016 at 2:03 am
dear all i have 3 SQL server nodes in availability group
and 3 AG (AG1, AG2, AG3 ) server 1 act as primary for AG1,
serve 2 act as primary for AG2, server 3 act as primary for AG3
i created backup maintenance plane for every AG on all servers
mean (server 1 have maintenance plane 1, 2, 3 and server 2 and server 3 the same )
my case is
when any AG fail to secondary the backup duplicate in execution
July 27, 2016 at 3:05 am
Try adding a startup sp on each node to turn off those jobs on the other nodes and turn their own job on
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 27, 2016 at 4:42 am
to declare
when AG1 fail to the secondary replica (server 2 for example)
now the backup maintenance plane on server 2 (primary now) occur twice (duplicate on execution)
July 27, 2016 at 8:20 am
Stop using maintenance plans. Get Ola.Hallengren.com's free and amazing maintenance suite.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 27, 2016 at 10:10 am
amrmnabil74 (7/27/2016)
to declarewhen AG1 fail to the secondary replica (server 2 for example)
now the backup maintenance plane on server 2 (primary now) occur twice (duplicate on execution)
The main issue here is msdb isn't smart enough to sync the history across all the nodes involved in an AG. I have a connect item opened, vote for it if it you think it helps. Microsoft might add it if it gets enough votes :).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply