Where has the SQL Server maintenance plan history gone to?
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
TIA!
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
TIA!
ASKER
That's right, SSMS shows no history. How do I find what is deleting it and stopping it? Or at least not to be so extreme?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If there's no history for a maintenance plan, which you are sure has run recently, then you're right something/someone has deleted the history.