• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 963
  • Last Modified:

log_shipping_monitor_error_detail

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?
0
PeterErhard
Asked:
PeterErhard
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
Have you tried using sp_cleanup_log_shipping_history system stored procedure with different @agent_type parameter?

http://msdn.microsoft.com/en-us/library/ms187374%28v=SQL.100%29.aspx

sp_cleanup_log_shipping_history
[ @agent_id = ] 'agent_id',
[ @agent_type = ] 'agent_type'


[ @agent_type = ] 'agent_type'
The type of log shipping job. 0 = Backup, 1 = Copy, 2 = Restore. agent_type is tinyint and cannot be NULL.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now