Thanks. I was leaning towards either restoring from the other instance or just copyimg from the install CD but wasn't sure of the impacts.

Regards,
Jim

-----Original Message-----
From: Chris Kempster [mailto:[Email Address Removed] Wednesday, March 24, 2004 10:02 AM
To: LazyDBA.com Discussion
Subject: RE: MSDB


Hi there

Nasty! :)

No backups? If you can export what packages you have, and look over your
maintenance plans, then do so. From here, either copy the msdb files from
your install CD and use these for your instance (reapply SP's thereafter),
or restore the msdb from another instance and review the originating server
column in sysjobs (from memory here).

Cheers

Ck


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page