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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-03 : 08:13:21
|
| sql writes "My server stopped suddenly. I had to re-install it and re-attach the databases. But unfortunately I could not restore my dts packages and jobs. Could anybody tell where the server saves them.THANKS." |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-09-03 : 08:17:32
|
| They are stored in the msdb database if you choose to save them locally or in the meta data services.Backup msdb regularly, or save the packages as structured storage files after each change. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-03 : 15:06:28
|
| DTS package are stored in sysdtspackages table in the msdb database.Tara |
|
|
|
|
|
|
Local packages