Recovering deleted DTS package

Posted on 2006-03-22
Last Modified: 2013-11-30
Is there any way to recover an accidentally deleted DTS package in SQL Server?
Question by:RPIS
    LVL 20

    Accepted Solution

    Do you have a recent backup of msdb?  If so, restore it to another database
    and copy rows from sysdtspackages.
    LVL 15

    Assisted Solution

    Restore it from your database backup of the msdb database.

    If you don't have a backup and you have deleted all versions of the DTS package -> then it's gone. :(

    Author Comment

    I will check with our tech on the backups.  Thanks to you both for the prompt responses.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now