November 22, 2021 at 8:13 am
Dear Friends,
Want to ask if its normal for the Maintenance Plans to exclude the database(s) in Always On availability Group ? I setup one and saw it works this way...Thanks in advance for ur valuable comments.
Thanks and Best Regards
Arshad
November 22, 2021 at 4:50 pm
Are you saying that the maintenance plan is excluding databases that are part of an availability group, or it's not backing up the databases on the secondary?
I have not used a maintenance plan for years, but I just created one on one of my AG servers. It did include the databases in the AG, but there was a warning message that it could not be run on a secondary.
Also have you considered using something like Ola Hallengren's maintenance solution?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 22, 2021 at 6:33 pm
This was removed by the editor as SPAM
November 24, 2021 at 7:29 am
@michael-2 , No its not backing the Primary Up...It ignores it (Though I unchecked the option 'Ignore Databases that are Not Online')..I get the warming you mentioned above , but it just doesn't backup the primary (Full and Trans log both).
THanks...Arshad
November 24, 2021 at 8:31 pm
What did you set the backup preference as for that availability group?
The maintenance plan should contain logic that uses that preference to determine where to perform the backups. It is possible you set it to secondary only so even though it runs through the list of databases - those in the AG cannot be backed up because it is the primary node.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 24, 2021 at 10:39 pm
@Michael , No its not backing the Primary Up...It ignores it (Though I unchecked the option 'Ignore Databases that are Not Online')..I get the warming you mentioned above , but it just doesn't backup the primary (Full and Trans log both).
THanks...Arshad
Dumb question. When you created the maintenance plan, did you actually create a schedule, and did it in turn create SQL Agent jobs?
Have you attempted to run the code within the job, which may give you exact errors?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 25, 2021 at 7:01 am
It backups the other databases. I asked it not to ignore any , but still leaves out the one in the Availability Group? thank you
November 25, 2021 at 3:24 pm
It backups the other databases. I asked it not to ignore any , but still leaves out the one in the Availability Group? thank you
So I will ask again - what is the backup preference defined for that AG? If it is NOT set to primary only - then the maintenance plan will 'skip' any databases that exist in that AG on the primary node and instead use the MP on the secondary to perform the backups.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 26, 2021 at 3:23 am
Arsh wrote:It backups the other databases. I asked it not to ignore any , but still leaves out the one in the Availability Group? thank you
So I will ask again - what is the backup preference defined for that AG? If it is NOT set to primary only - then the maintenance plan will 'skip' any databases that exist in that AG on the primary node and instead use the MP on the secondary to perform the backups.
I agree. How is the AG set up??
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply