Maintenance Plan succeeds, but does not perform backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Maintenance Plan succeeds, but does not...

Maintenance Plan succeeds, but does not perform backup

Rate Topic

Display Mode

Topic Options

Author

Message

tweeaked

Posted Wednesday, September 19, 2012 3:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 21, 2012 11:08 AM
Points: 4, Visits: 12

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!

Post #1361649

durai nagarajan

Posted Thursday, September 20, 2012 8:29 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:05 AM
Points: 856, Visits: 2,115

Anything on maintanence plan history or job history?

Regards
Durai Nagarajan

Post #1362026

opc.three

Posted Thursday, September 20, 2012 10:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:27 PM
Points: 6,735, Visits: 11,788

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1362122

tweeaked

Posted Thursday, September 20, 2012 10:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 21, 2012 11:08 AM
Points: 4, Visits: 12

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

New Thread

Post #1362144

« Prev Topic | Next Topic »

Permissions