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 |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2004-03-05 : 03:12:27
|
Hi, EverbodyAnybody know how to backup/restore the DTS package? I have a lot of DTS package but my problem is how to backup and restore to other server. I did one by one, like open the package and save as to another server. there is other way to do this in one time. Thank you in advanced and more power  Andrian |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 04:07:38
|
| DTS Packages are stored in sysdtspackages in msdb. You could copy the relevant records between servers for msdb, with the obvious caveat that you should backup the destination msdb first!Raymond |
 |
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2004-03-07 : 21:50:00
|
| Thanks a lot Raymond. More power to you. |
|
|
|
|
|
|
Backup DTS Package