September 19, 2012 at 3:17 pm
I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups of the only User database.
The task is succeeding, the subplan is succeeding, but there is no backup file when it's done.
I get the same results when I delete the Maintenance Plan and re-create it from scratch. 'FailPackageOnFailure' and 'FailParentOnFailure' are both set to True on the Subplan and the task. I have also tried enabling 'ignore Replica Priority' in the task, which didn't help.
What am I missing here?
Thanks in advance!
September 20, 2012 at 8:29 am
Anything on maintanence plan history or job history?
Regards
Durai Nagarajan
September 20, 2012 at 10:10 am
This should probably be moved to the SQL 2012 - General Forum. You may get more page views that way. Some very qualified folks have stopped watching the 2005 Forums and are only focusing on 2008 and above.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 20, 2012 at 10:33 am
Oh sigh. I thought I did post it in the 2012 forum. I could swear that's what I clicked on. Sorry.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply