I groom alerts monthly to reclaim disk space. This month when trying I get the following error
Anyone have a suggestion on what I can do or maybe a script to complete this outside of the GUI? I have a ticket open but have not heard anything in a week.
I was hoping Idera would provide the obvious simple solution but I could not wait any longer due to disk space issues. I deleted alerts older then 35 days from SQLcompliance and shrank the DB.
delete from Alerts
where created < (getdate() - 35)
Powered by IDERA