Hello,

I have a dead instance with lots of DTS scripts that were not backed up. Is
there a way to extract them from the msdbdata.mdf file? This is SQL Server
2000 SP3a. I do not have a backup of the msdb either.

Thanks

-- Jake

You will need to attach the database, or swap it into the correct location
of an existing server. You need to get the DB back online to then extract
the packages from the sysdtspackages table.


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

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

I have the same question for a SQL Server 7.0 db. I reattached the msdb
database and got it online. I don't see a msdb..sysdtspackages table, however
if I issue a select statement against the table, I get no rows returned.
There are some tables that begin with DTS (ie. DTSTransferObjectClass) that
have records and looking at those records, show information that appears to
be related to this DTS job that I'm trying to recover. Is there a way to do
this with just the MSDB.mdf and .ldf files?
TIA,
Chris

"Darren Green" wrote: