June 11, 2009 at 5:57 am
Hi,
Can we truncate from [dbo].[sysdtspackages] in msdb since the
table size has grown upto 3.5gb.
Regards
Prasanna.
June 11, 2009 at 8:00 am
prsnn_shetty (6/11/2009)
Can we truncate from [dbo].[sysdtspackages] in msdb since the
table size has grown upto 3.5gb.
quote]
This table actually stores your DTS packages and previous versions. So if you truncate the table, you will loose all or packages. It's probably a better approach to go through your DTS packages and check which (if any) can be removed from your server.
Also you might be able to remove some older versions.
[font="Verdana"]Markus Bohse[/font]
June 11, 2009 at 8:30 am
There is script in the SSC library titled "Delete old versions of DTS packages" which should solve your problem.. You can add the stored procedure and then have the sp run by a job.
http://www.sqlservercentral.com/scripts/Miscellaneous/30606/
SQL = Scarcely Qualifies as a Language
June 11, 2009 at 9:18 am
Be sure that you don't need old versions of the packages. Likely you don't, but be sure that people are aware you are getting rid of these.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply