Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: Retrieving DTS jobs from MSDB backup

    Our sysadmin accidentally uninstalled SQL Server started to panic and reinstalled. Thankfully the data/transaction files to our important databases were still present and I simply reattached them but our DTS packages our gone.

    However, we've done weekly backups of the msdb database. How do I get the DTS jobs out of these backups?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You must attach the MSDB database or restore from the backup in order to get those DTS packages that are saved in SQL Server. Refer to the books online for RESTORE topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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