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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-07-26 : 03:08:36
|
| Hi,In order to backup by DTS packages, currently I individually open each DTS package in Design mode and then save them as Structured Storage File. Since I have a # of DTS packages and due to the current nature of the work these are changed frequently therefore this backing activity takes time.Is there a simpler solution via which I canbackup all my DTS packages?Many TIA. |
|
|
bponsen
Starting Member
6 Posts |
Posted - 2004-07-26 : 06:03:08
|
| I found a third party tool that I'm currently testing locally. DTS backup 2000. check it out on this site:http://www.sqldts.com/default.aspxPerhaps this is what you're looking for?Good luck,Bart. |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2004-07-26 : 06:11:56
|
| Thanks. I'll check out the site. I guess the solution lies only in a 3rd party SW? :( |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-26 : 09:47:17
|
| ??? Just backup the msdb database. How hard is that? :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-07-27 : 05:55:33
|
| DTSBackup does work quite well, though.-------Moo. :) |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2004-07-28 : 01:33:32
|
| Thanks all. Will try out the suggestion by tduggan too.Thanks & Regards.-J |
|
|
|
|
|
|
Is there a easy way to backup my DTSs?