Solved

getting error from maint jobs after migration to sql 2005

Posted on 2008-06-20
4
1,006 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 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

820 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