I had to reinstall SQL, and after I re-attached all of my
databases, I noticed that all of my DTS packages were
gone. I saw in another post that I need to restore my
MSDB database.
1. Was this overwritten automatically by the reinstall?
2. What will this affect? Can I do this with users in
other databases on the same server, or do I have to wait
until everyone is out?
3. Are there any other steps I need to take besides stop
sql agent, restore msdb, then start sql agent?
4. I'm very new to SQL, but I have to get these jobs back
becaues I don't know how to recreate them.

Thanks,
BoB

"BoB" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Probably yes.

I would restore the msdb as a new name, and then copy the packages accross,
unless you want all of MSDB back, such as jobs, alerts, and packages, in
which case restore the DB. To restore a DB over the top of an existing on,
you will need to close all connections to that DB, but other DBs are fine.