?
Solved

getting error from maint jobs after migration to sql 2005

Posted on 2008-06-20
4
Medium Priority
?
1,032 Views
Last Modified: 2008-11-12
i'm getting the error listed below after migrating my databases to my new sql 2005 server, the jobs were fine during the test phase of the migration, but after moving the DB over perminatly the jobs started failing.

Executed as user: MCGPLC\ChiSQLServer. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:04:16 AM  Warning: 2008-06-20 00:04:17.64     Code: 0x80012017     Source: Maint_plan_system_backups      Description: The package path referenced an object that cannot be found: "\Package\Subplan_1.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found.  End Warning  DTExec: Could not set \Package\Subplan_1.Disable value to false.  Started:  12:04:16 AM  Finished: 12:04:17 AM  Elapsed:  0.859 seconds.  The package execution failed.  The step failed.
0
Comment
Question by:richa1960
  • 2
4 Comments
 
LVL 4

Expert Comment

by:zx10r
ID: 21832778
did you move over the maintenance plans as well?
0
 

Author Comment

by:richa1960
ID: 21834342
I tried but the script kept failing, so i rebuilt them from scratch,
0
 

Expert Comment

by:the_kraken
ID: 22059311
Anyone have any luck fixing this?  I had the same issue as richa1960; I moved a maint. plan over to the new server, couldn't get it to run and ended up rebuilding it.  Now I get the error listed above.  Any suggestions or fixes?  Thanks,
0
 

Accepted Solution

by:
the_kraken earned 1500 total points
ID: 22060427
I ended up opening the maint. plan itself and setting the schedule from there versus changing it on the scheduled job.  It seems like this shouldn't make a difference but it did in my case.  Hope this helps.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question