[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

getting error from maint jobs after migration to sql 2005

Posted on 2008-06-20
4
Medium Priority
?
1,027 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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 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.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

649 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