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
Solved

Restoring Jobs in SQL 2000

Posted on 2009-04-02
10
189 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
  • 5
  • 5
10 Comments
 
LVL 11

Expert Comment

by:N R
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 11

Expert Comment

by:N R
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 11

Accepted Solution

by:
N R 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 11

Expert Comment

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

Author Comment

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

Expert Comment

by:N R
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 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