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 |
|
dcouot
Starting Member
2 Posts |
 Posted - 2005-09-26 : 05:46:33
|
| Importing and Exporting with DTS is OK, but how to export and import DTS for backup purposes. The backup functionality does not backup the DTS nor does it offer any option on this regard. I found a way to save the DTS outside of the server environment, but not to restore them.Any idea ?Thanks. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-26 : 12:11:17
|
| DTS packages are stored in the msdb database. do a nightly full backup of msdb and you should be fine. It is also a good idea to practice a recovery or two.-ec |
 |
|
|
|
|
|
How to export and Import DTS