How to recover the accidently deleted DTS package in the SQL Server

Is there any way to recover an accidentally deleted DTS package in SQL Server. If yes, please let me know know all the process and steps to recover the DTS package in the SQL Server.
sridhar_ravvaAsked:
Who is Participating?
 
Anthony PerkinsCommented:
>>I am following you now what you are saying...i got it..but what if we don't have the MSDB Backup before deleting the DTS Package<<
You are nearly out of luck.

>> is there any other alternate way apart from this method<<
If you are using SQL Server 2000, you may be able to recover it from the Transaction log using some third party tool such as:
SQL Log Rescue™
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
0
 
Anthony PerkinsCommented:
If you had saved it in SQL Server you can restore it from a recent MSDB backup.
0
 
sridhar_ravvaAuthor Commented:
But how to restore it from MSDB backup...can you explain me in detail in steps ? Thanks
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Anthony PerkinsCommented:
The DTS packages are kept in a table called sysdtspackages.  

As to how you restore it, it really depends.  For example we use Red Gate SQL Backup and SQL Data Compare we can use those tools to compare and copy the missing rows from the backup.

If all you have is MS backup than you will have to restore the whole MSDB database as a new database called say MSDB_Old.  You can then copy the missing row(s) from the sysdtspackages in MSDB_Old to MSDB.
0
 
sridhar_ravvaAuthor Commented:
i am sorry, i am new to this process, I am not able to follow you on this..can you provide me with some examples, screenshots for this entire process and steps that would be great, Thanks
0
 
Anthony PerkinsCommented:
I am afraid not.  Hopefully someone will step up to the plate.
0
 
sridhar_ravvaAuthor Commented:
I would appreciate if you or somebody can explain me the process in detail...as I am not following the above steps esp. :

"If all you have is MS backup than you will have to restore the whole MSDB database as a new database called say MSDB_Old.  You can then copy the missing row(s) from the sysdtspackages in MSDB_Old to MSDB."

Thanks.
0
 
Anthony PerkinsCommented:
Ok, it does not look like anyone can help you, so let me try.  Do you know how to restore from a backup?  If not ask your DBA to restore your last MSDB backup before you deleted the DTS package as a database called MSDB_Old.
0
 
sridhar_ravvaAuthor Commented:
I am following you now what you are saying...i got it..but what if we don't have the MSDB Backup before deleting the DTS Package, then will it not be possible for me to recover the DTS Package, is there any other alternate way apart from this method..please let me know...
0
 
sridhar_ravvaAuthor Commented:
Sure, Thanks for the information.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.