I was forced to reinstall SQL due to some problems we were
having. Unfortunatley I didn't know that our old DBA had
quite a few DTS jobs that are now gone. Is there any way
to recover these jobs?? If so could someone please give
me simple instructions? I have to get these jobs back by
tomorrow night, and I'm not that familiar with SQL. Any
help would be greatly greatly greatly appreciated.

If you were saving the packages to SQL Server, you need to
restore the msdb database to get the packages back.

-Sue

On Wed, 16 Jun 2004 19:29:31 -0700, "Dan"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

If I restore the msdb database, will all of the DTS jobs
be back, or is there anythinig else I will need to do?

Also, does the msdb database get over-written on a
reinstall, or is there some way for me to recover it
without going to tape?

Thank you so much for any help.

The msdb has the packages as well as jobs. If your packages reference
other user databases on the server, you need to restore those as well.
I'm not sure what process you went through on the reinstall but
generally you would end up with new system databases and would no
longer have your user databases. That's what it sounds like in your
case. If your only backups were on tape, then you need to get those
backups from the tape to restore your databases.

-Sue

On Thu, 17 Jun 2004 06:29:24 -0700, "Dan"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Thank you so very much for your help. I really do
appreciate it.

No problem...glad to be of help. If you run into any
problems trying to restore, just post to the server
newsgroup (microsoft.public.sqlserver.server). You may want
to read the following article which walks through the steps
of restoring databases to a new server:
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
The SQL Server 2000 version of the article uses sp_attachdb
and sp_detachdb which isn't going to help in your case. But
the article should give you an idea on the steps to restore.

-Sue

On Thu, 17 Jun 2004 11:25:09 -0700,
<anonymous (AT) discussions (DOT) microsoft.com> wrote: