Maintenance Plan succeeds, but does not perform backup

  • 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!

  • Anything on maintanence plan history or job history?

    Regards
    Durai Nagarajan

  • 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

  • Oh sigh. I thought I did post it in the 2012 forum. I could swear that's what I clicked on. Sorry.

    New Thread

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply