Post reply

maintenance plan history not being kept. Is there something besides cleanup history maintenance plan that could be doing this?

  • February 18, 2014 at 6:55 am

    #285798

    Hi. I'm using sql server 2005, and the maintenance plan histories weren't being kept since multiple maintenance plans had cleanup history with parameter of 1 day.

    I modified all of the cleanup history maintenace plans and changed 1 day to 10 days, but none of the maintenance plan history show history from before 2/17, so only 2 days is being kept.

    Is there any other place I need to look to see what may have deleted the history for maintenance plans older than 2 days?

    I'd appreciate any suggestions on how to find what's deleting the history. Thanks.

  • February 18, 2014 at 7:26 am

    #1689896

    In sqlagent properties there is a history tab, if the log history size is too small and you have a lot of jobs, history will be truncated sooner than you individual job settings suggest.

    ---------------------------------------------------------------------

  • February 18, 2014 at 7:33 am

    #1689898

    Thanks very much for the information, George. That could be the issue, since it was only set to 1000 rows in properties.

    I just increased it to 500000, and will see tomorrow if more than 2 days' history is showing up, and will mark your reply as the answer if it works.

  • February 18, 2014 at 7:36 am

    #1689900

    500000 could be a bit over the top, it has an effect on msdb size.

    ---------------------------------------------------------------------

  • February 18, 2014 at 7:53 am

    #1689915

    Thanks, George.

    I'll monitor the size of msdb, and see how it's growing, and see how much space it will be with 10 days' history, and reduce the number of days if it's too much.

  • February 19, 2014 at 5:56 am

    #1690216

    Thanks very much, George. It worked.

  • February 19, 2014 at 6:23 am

    #1690232

    good stuff.

    ---------------------------------------------------------------------

Viewing 7 posts - 1 through 6 (of 6 total)

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