Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    8

    Question Unanswered: Urgent : Recover DTS Package

    Dear All,

    Can any one tell me how to recover the DTS Package from SQL Server 2000.
    The package has different versions, when i tried to edit that version i can see only an empty screen. Is there any way that we can get the related physical file ? How can this physical file be used for restoring the package ?

    Please tell me Is there any other alternatives to get the DTS Package back.

    Thanks In advance...

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    All DTS packages are stored in MSDB database. If you are doing a lot of DTS work, make sure you do hourly MSDB backups to minimise a situation like yours.

    Cheers,

  3. #3
    Join Date
    Aug 2004
    Posts
    8

    Thumbs up

    Thanks again.

    Luckily, today I can able to see all the objects inside the package; I don’t understand yesterday I can’t see any objects, how come today? Any idea?
    But I started to take MSDB Backup.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •