Restoring repository packages

#1

Hi,
due to a screwup when updating DTS jobs, many jobs on our production system
have been destroyed. Form research I understand it is possible to restore
local jobs from msdb..sysdtspackages.
Is it also possible to restore packages stored in the repository ?
thanks

conor

#2

sysdtspackages is only for Local Packages (SQL Server Packages). To recover
your repository packages you will need to restore your msdb database.

--
Darren Green
http://www.sqldts.com

"CJL" <conor (AT) davy (DOT) ie> wrote

Quote:

Hi,
due to a screwup when updating DTS jobs, many jobs on our production
system
have been destroyed. Form research I understand it is possible to restore
local jobs from msdb..sysdtspackages.
Is it also possible to restore packages stored in the repository ?
thanks

conor

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Restoring repository packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Restoring repository packages - 07-16-2003 , 07:09 AM

Re: Restoring repository packages - 07-16-2003 , 09:08 AM