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 |
|
cesark
Posting Yak Master
215 Posts |
 Posted - 2006-10-17 : 12:27:49
|
| Hello,Weekly I make a database backup from Enterprise Manager (right click to databaseName and I choose the option to make a copy to a CD). But now I want also to make a copy/backup of my DTS packages, Is this possible? If so, which are the steps to do it?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-17 : 12:40:22
|
| DTS Packages are stored in msdb, so just backup that database.Tara Kizer |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-10-17 : 12:42:25
|
| Have a look at this page on www.SQLDTS.com: [url]http://www.sqldts.com/default.aspx?202[/url].Mark |
|
|
|
cesark
Posting Yak Master
215 Posts |
Posted - 2006-10-17 : 12:54:47
|
| So, although seems another separate 'folder', making a backup of the DB which DTS belongs to, DTS packages are stored automatically with the DB files? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-17 : 12:58:21
|
| They are stored in the sysdtspackages table in msdb database. So a backup of that database also backs up your packages.Tara Kizer |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-10-18 : 02:57:11
|
| Hi tara is right as always.To make it more simpler if you dont wanna backup your msdb database you can use"SAVE AS " option in your DTS packages and you can save these packages to anyother location.RegardsNitin |
|
|
|
cesark
Posting Yak Master
215 Posts |
Posted - 2006-10-18 : 03:41:56
|
| Hi Nitin,I just was thinking in that alternative because seems more logical (it only saves the configured DTS packages) and it is lighter in Kb. Anyway, the page that Mark pointed to says that both options are valid.. But at a first glance I prefer store packages as file packages (Save the package as a Structured Storage File) |
|
|
|
|
|
|
Can I make a Backup of DTS packages?