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 |
|
shaunc
Starting Member
28 Posts |
 Posted - 2007-09-20 : 17:36:52
|
| Hi all,We have a number of DTS packages that have been tweaked hundreds of times over the years. This has caused some of our msdb databases to grow far larger than necessary, since a separate copy of every package is stored for each revision. We don't care about being able to revert any package any further back than 90 days, so all the older edits are just wasting space and increasing backup time.Is it safe to delete the offending rows directly out of sysdtspackages? I don't want to delete a bunch of unwanted rows and then suddenly have EM refuse to open packages because it's expecting the old versions to be there, too. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-20 : 23:48:32
|
| If you know which row to delete, it's fine. Although it's not supported way. |
 |
|
|
|
|
|
Purging old versions of DTS packages?