Where has the SQL Server maintenance plan history gone to?
Posted on 2014-04-23
I recently went to review the history of various maintenance plans that i have set up for things like backups, runstats and reorgs, etc.
None of it was there.
There is a task in the daily clean up maintenance plans that removes old bak and trn files. It also removes history older than 4 weeks. Could this be the culprit? But supposed to keep 4 weeks worth.
I checked on the agent history and it exists. I just don't have any maintenance plan history.
What is causing this behaviour and what can I do to get the plan history to start being saved again?
This is happening in both SQL Server 2005 and SQL Server 2012