Restore of DTS package

• jG

  SSCrazy

  Points: 2505

  More actions

  May 17, 2002 at 8:17 am

  #78756

  I have a deleted DTS package that was in the msdb dbase. I restored the msdb dbase on the same server as a different name. I am wanting to extract the specific DTS package that was deleted back into the msdb dbase. Does anybody no a good procedure for this. I was able to export out of the sysdtspackages. Is there more related data that needs to be moved over to complete the recovery?

  -JG

  
  -JG

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 17, 2002 at 8:41 am

  #429366

  Check out this article by Steve http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)