Recovering deleted DTS package

Is there any way to recover an accidentally deleted DTS package in SQL Server?
RPISAsked:
Who is Participating?
 
SireesConnect With a Mentor Commented:
Do you have a recent backup of msdb?  If so, restore it to another database
and copy rows from sysdtspackages.
0
 
DonKronosConnect With a Mentor Commented:
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. :(
0
 
RPISAuthor Commented:
I will check with our tech on the backups.  Thanks to you both for the prompt responses.
0
All Courses

From novice to tech pro — start learning today.