Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup Maintenance Plans failed


Backup Maintenance Plans failed

Author
Message
reddi_arjun
reddi_arjun
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 103
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...
rajganesh.dba
rajganesh.dba
SSC-Addicted
SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)SSC-Addicted (422 reputation)

Group: General Forum Members
Points: 422 Visits: 323
First plz clarify whether the server is moved to different domain and secondly check whether the maintenance plan still exists
reddi_arjun
reddi_arjun
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 103
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.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5348 Visits: 9860
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 opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: Administrators
Points: 42504 Visits: 18877
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
My Blog: www.voiceofthedba.com
Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3663 Visits: 2485
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."
reddi_arjun
reddi_arjun
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 103
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.
mutusp23
mutusp23
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
ertan.sumer
ertan.sumer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 80
After changing Simple to Full you need to have a fresh backup.
rvphx
rvphx
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 Visits: 296
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search