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

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:

Thanks for the info!!!!

Mark
"jaylou" <jaylou (AT) discussions (DOT) microsoft.com> wrote