Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schuhtl
Posting Yak Master
102 Posts |
 Posted - 2003-08-25 : 08:51:44
|
| I don't have a current backup and accidently deleted a DTS package I had been working on for alomost 1 day. Is there any way to recover this? |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-08-25 : 11:02:45
|
| I don't think so. If you had a current backup of your msdb database or if you had saved the DTS-package as a file, but not without any kind of saved package. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-25 : 12:22:44
|
| DTS packages that are saved to SQL Server are stored in sysdtspackages in the msdb database. As Andraax mentioned, if you had an msdb database backup, then you could recover it although you would probably be missing recent updates to it. Source control should be used for DTS packages if they are important. You could save them to a file and then put them in VSS or some other source control package.Tara |
|
|
|
|
|
|
Recover DTS package