Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance Plan succeeds, but does not perform backup Expand / Collapse
Author
Message
Posted Wednesday, September 19, 2012 3:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, September 20, 2012 8:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Anything on maintanence plan history or job history?



Regards
Durai Nagarajan
Post #1362026
Posted Thursday, September 20, 2012 10:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:47 AM
Points: 7,126, Visits: 12,727
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
Post #1362122
Posted Thursday, September 20, 2012 10:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse