Just downloaded the last version of sp_blitz from github, and have run it on two different database servers.

On both of them it reports both of the following findings:

  1. MSDB Backup History Not Purged
  2. MSDB Backup History Purged Too Frequently

On one of the servers there were 2 years of backup history, but on the other there were only one month of backup history.

Anyone know why both of these are reported? Seems to contradict each other.

Could it be a bug in sp_blitz?

  • Yes, I noticed that yesterday too. I'd open up a new issue on Github seeing as there are no open issues regarding this problem and explain what you found. – John K. N. Aug 30 '17 at 13:53
  • Look for closed issues, github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/…. This has been logged and handled. – tpet Aug 31 '17 at 22:09
  • Thx to both. I just downloaded it again, and it seems that it has been fixed in the version uploaded some hours ago. Do they publish fixes only once a month, is that why I had the problem on the version downloaded 2 days ago, even though the issue was fixed and closed? – GHauan Sep 1 '17 at 6:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.