Post reply

Safely delete package logs?

  • September 13, 2004 at 8:41 am

    #60192

    I want to automate deltion of old package logs.  I know something about the sysdtssteplog and sysdtspackagelog tables in the msdb database.  Can I safely delete from those two tables?  Are there other tables that must be addressed also?  Any other suggestions?

    Thanks,

    Larry

    Larry

  • September 14, 2004 at 5:32 pm

    #523087

    Take a look at my script here,

    http://qa.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=606

    This removes old versions of packages and their related logs. You can modify this to just remove the logs if you like. There is probably a script to do just that somewhere in the script library.

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

Viewing 2 posts - 1 through 1 (of 1 total)

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