<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Backup Maintenance Plans failed
Backup Maintenance Plans failed
Rate Topic
Display Mode
Topic Options
Author
Message
reddi_arjun
reddi_arjun
Posted Friday, March 20, 2009 2:52 PM
Grasshopper
Group: General Forum Members
Last Login: Today @ 7:31 PM
Points: 15,
Visits: 85
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
rajganesh.dba
rajganesh.dba
Posted Saturday, March 21, 2009 1:34 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, October 25, 2012 1:22 PM
Points: 385,
Visits: 297
First plz clarify whether the server is moved to different domain and secondly check whether the maintenance plan still exists
Post #680864
reddi_arjun
reddi_arjun
Posted Saturday, March 21, 2009 9:34 PM
Grasshopper
Group: General Forum Members
Last Login: Today @ 7:31 PM
Points: 15,
Visits: 85
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
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Sunday, March 22, 2009 2:33 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, March 22, 2009 3:16 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421,
Visits: 13,734
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
rudy - Doctor "X"
rudy - Doctor "X"
Posted Monday, March 23, 2009 2:42 PM
Hall of Fame
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 PM
Points: 3,108,
Visits: 2,114
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
reddi_arjun
reddi_arjun
Posted Tuesday, March 31, 2009 2:49 PM
Grasshopper
Group: General Forum Members
Last Login: Today @ 7:31 PM
Points: 15,
Visits: 85
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
mutusp23
mutusp23
Posted Monday, November 16, 2009 9:24 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, January 06, 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
ertan.sumer
ertan.sumer
Posted Monday, May 16, 2011 1:43 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 7:26 PM
Points: 1,
Visits: 48
After changing Simple to Full you need to have a fresh backup.
Post #1109126
rvphx
rvphx
Posted Friday, February 03, 2012 8:17 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 10:54 AM
Points: 120,
Visits: 278
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
