Networks

Ask something
Question Locked

Jobs in SQL 2000

0 helpful
3 replies

by countyworker01

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 all of the databases that were on that server, but those .bak files don't contain any of the jobs. I do have an image that I can mount of the entire drive that had SQL installed, so I'm hoping that those jobs are stored somewhere that I can just import onto the new server.

3 replies

by shellbot

Yes, the jobs are stored within the msdb..

Can't "import" them as such, unless you've got software for it..I think RedGate does it..(a few others around as well)

Mount the image, use Enterprise Manager, Management, Jobs..choose a job, and generate a SQL script and write them to a file. Then take those files to the new server and run them.

This discussion is closed to new replies.