Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

can I salvage DTS local packages from msdbdata.mdf?

SQL 7.0
Win2K Server

power supply burned out motherboard & tape drive, rendered machine and drives useless
retrieved all MDFs and LDFs from drives

acquired new machine, but could not get old drives to work with new board
thus got new drives witha new install of Win2K Server & SQL7

was able to successfully reattach all MDFs and LDFs
BUT all DTS packages were local (and thus in msdb)

so I have msdbdata.mdf from old machine/drives and need to retrieve the DTS packages.  Any way I can do this?  
  • 2
1 Solution
Brendt HessSenior DBACommented:
Attach it as a different database.  You need not keep the DB name the same when attaching.  Try:

sp_attach_single_file_db 'OldMSDBData', 'C:\OldData\msdbdata.mdf'

Once it is attached, you can *try* to get the info from the old sysdtspackages table to the new one.  You will probably need to turn on inserts to system tables, though.

jwa1107Author Commented:
the last entry help the best; i attempted options #1 and #2 with no personal success, but #3 seems to have worked.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now