Solved

Restoring Jobs in SQL 2000

Posted on 2009-04-02
10
193 Views
Last Modified: 2012-05-06
Does anyone know where the jobs are stored in SQL 2000? The reason I'm asking is because we recently replaced a server and installed SQL 2005 on it. Apparently, the old server had some SQL jobs on it that I need to recover (not backup jobs or shrink jobs, but other types).

I have a full backup of the entire server done with Backup Exec 11d.  Do I need to restore the entire server or is there another way to find and restore just the jobs from 2000 to our new 2005?
0
Comment
Question by:megnin
[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
  • 5
  • 5
10 Comments
 
LVL 12

Expert Comment

by:Nathan Riley
ID: 24053874
Restore the jobs or DTS packages?  If DTS packages I believe you have to save them as a structured storage file from within enterprise manager.  Which would mean you need to restore the server.
0
 
LVL 12

Expert Comment

by:Nathan Riley
ID: 24053884
As long as the backup program restores everything including packages.  I know a normal backup will not save the DTS packages.
0
 
LVL 1

Author Comment

by:megnin
ID: 24053912
Are the Jobs stored in the file system like in C:\SERVER\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\JOBS   ?

Where we could restore that file and then look at it to recreate the job on the new server?
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 12

Accepted Solution

by:
Nathan Riley earned 500 total points
ID: 24054060
I would just restore it then go into enterprise manager and right click jobs and create a script then drop that into a query window on 2005 and execute it.
0
 
LVL 1

Author Comment

by:megnin
ID: 24054087
Yeah, we want to try to avoid having to restore the server (300GB backup) over our slow network.  We would like to be able to use Backup Exec to pull an appropriate file from the file system.  We just don't know what that file would be of if that's possible.
0
 
LVL 12

Expert Comment

by:Nathan Riley
ID: 24054153
I believe that is your only option at this point.
0
 
LVL 1

Author Comment

by:megnin
ID: 24054185
Bummer.  ;-)
0
 
LVL 12

Expert Comment

by:Nathan Riley
ID: 24054194
Hey better then doing it all from scratch if you have many jobs.
0
 
LVL 1

Author Comment

by:megnin
ID: 24072193
No, there's only one job that we forgot about when we upgraded from 2000 to 2005.  It belongs to some application that interfaces with our Financial software.  
It just seems weird that you can't just pull a file out of C:\SERVER\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\JOBS and either read it if it's just text and re-create it on the new server or something.  Restoring an entire server for that just seems like 2 Billion times overkill.
0
 
LVL 1

Author Closing Comment

by:megnin
ID: 31565969
Thank you.  We'll have to remember to do that in advance next time.  ;-}
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

636 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