"jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:3B103F22-156C-4D49-BA69-F6CCE60375E8@microsoft.com...
> If you have a backup of the MSDB Database you can restore that over the
> existing one and that will bring back your DTS and Scheduled jobs.
>
> There are articles on restoring MSDB in BOL and google.
>
> Before restoring MSDB stop the agent services.
> In the table sysjobs make sure originating_server is the same name as your
> new server name.
>
> HTH,
> Joe
>
>
> "Mark Andrews" wrote:
>
> > One of our SQL Servers just died and the network team was doing backups
of
> > all databases but no other types of backups.
> >
> > Is it possible to get back DTS packages?
> >
> > Same question for SQL Jobs?
> >
> > Thanks in advance,
> > Mark
> >
> >
> >