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

Backup Maintenance Plans failed Expand / Collapse
Author
Message
Posted Friday, March 20, 2009 2:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 24, 2013 11:22 AM
Points: 15, Visits: 95

The Maintenance plans i was using for backups was running fine till yesterday.
Yesterday night we moved the server from one data center to another physically and started the services.

Since then the maintenance plans are failing.

Actually the view history tab of maintenance plan does not show anything. the error is shown in SQL server jobs only. i think the job is not able to go to maintenance plan.
Here is the error.

Executed as user: Domain\devsqlservice. his task is "Maintenance Plan Reporting Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2009-03-20 16:42:23.56 Code: 0xC0024107 Source: Reporting Task for subplan-{587BE1DE-326E-4A79-B159-9B0A65E70316} Description: There were errors during task validation. End Error Error: 2009-03-20 16:42:23.56 Code: 0xC0010025 Source: TLog_Backup Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:42:07 PM Finished: 4:42:23 PM Elapsed: 15.61 seconds. The package execution failed. The step failed.

Please let me know if you need more info...
Post #680730
Posted Saturday, March 21, 2009 1:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:05 PM
Points: 386, Visits: 318
First plz clarify whether the server is moved to different domain and secondly check whether the maintenance plan still exists
Post #680864
Posted Saturday, March 21, 2009 9:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 24, 2013 11:22 AM
Points: 15, Visits: 95


i have checked the domain and the maintenance plans.
Domain is same and the maintenanace plans exists.
other SQL server jobs are working fine but the backup subplans created during the creation of maintenance plans are failing.

i tried to create a sql job which takes the backup of all databases but i is also failing.
Post #681021
Posted Sunday, March 22, 2009 2:33 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:16 PM
Points: 4,389, Visits: 9,526
Did you change the server name?
Do you backup to a network share that is no longer available?

Can you open the maintenance plans and verify the connection and setup for each plan?

One thing you can try is dropping the server and adding it back in:

Execute sp_dropserver 'your instance name';
Execute sp_addserver 'your instance name', 'local';



Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #681138
Posted Sunday, March 22, 2009 3:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:37 PM
Points: 33,189, Visits: 15,329
Can you set up logging for the maint plan and capture a text file log? It should have more info in there.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #681146
Posted Monday, March 23, 2009 2:42 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:24 AM
Points: 3,214, Visits: 2,332
Double check the recovery mode of the database. The output states the TLOG portion failed - if the database is in 'simple' recovery mode that could explain it.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #681867
Posted Tuesday, March 31, 2009 2:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 24, 2013 11:22 AM
Points: 15, Visits: 95

it is not working for any of the maintenance plans that we set up...

i have created the sql agent jobs instead of maintenance plans and they are running fine.

I think the problem is with SSIS packages that will be created at the time of maintenance plans.

Post #687470
Posted Monday, November 16, 2009 9:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 6, 2010 7:06 PM
Points: 1, Visits: 15
Jeffrey Williams-493691 (3/22/2009)
Did you change the server name?
Do you backup to a network share that is no longer available?

Can you open the maintenance plans and verify the connection and setup for each plan?

One thing you can try is dropping the server and adding it back in:

Execute sp_dropserver 'your instance name';
Execute sp_addserver 'your instance name', 'local';



how to run this
Post #819466
Posted Monday, May 16, 2011 1:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 1:04 AM
Points: 1, Visits: 59
After changing Simple to Full you need to have a fresh backup.
Post #1109126
Posted Friday, February 3, 2012 8:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:55 AM
Points: 120, Visits: 292
Answer to a very old problem..I know.
But I got into this situation when we changed our server.
The maintenance plans are SSIS packages stored in the Package Store of your server.
Once you upgrade your server and export your packages, the XML for the package wont get changed automatically and SSMS doesnt have any way of making that change for you.

Hence you will need to change the XML itself. Please use the script found at

http://msdn.microsoft.com/en-us/library/ms143799(v=sql.90).aspx (Scroll to the comments section..some good fella provided the script in there).

This script works perfectly fine and you will be able to see the changes being made. Good Luck to anyone facing the same issue.
Post #1246541
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse