MSDB size rocketed

Question

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

QPR SSC Eights! Points: 814 More actions · Answer 1

Answered that one meself too.

EM, right click packages, versions, delete.

I'll have RSI by the time I delete this lot!

many thanks for all your help Phil.

philcart SSC-Forever Points: 47794 More actions · Answer 2

I posted this in the script library ages ago to remove old versions.

This removes the version and the logs associated with that version.

It might be an idea to setup a routine maintenance job that clears out the old stuff.

--------------------
Colt 45 - the original point and click interface

philcart SSC-Forever Points: 47794 More actions · Answer 3

Also, you can "roll-back" to prior versions by opening the old version and saving the package again. which creates a newer version.

--------------------
Colt 45 - the original point and click interface

Rich Fisher-482377 Grasshopper Points: 15 More actions · Answer 4

Late to this question - new to server and only noticed today that we have a similar problem.

Reason? We have an sp that creates new versions of DTS packages by changing the source file name.

Works OK, except that no-one thought to drop 'old' versions of the DTS package - table, db and .bak is around 30 Gigabytes !

philcart SSC-Forever Points: 47794 More actions · Answer 5

Rick, so were you able to sort out the old versions?

--------------------
Colt 45 - the original point and click interface