The log_shipping_monitor_error_detail table in the msdb database has grown out of control with many errors in there. I've fixed the errors up, but I'm not sure how to clear all the rows within the table. There's a crazy 1,815,556 of them using 4GB of space.
Can I just truncate the table or is there something in particular I have to do ?
I've tried running "sp_cleanup_log_shipping_history" but it doesn't clear anything out.
What can I do here?