Solved

Restoring Jobs in SQL 2000

Posted on 2009-04-02
10
186 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
 
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now