Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Log shipping alerting on databases that no longer exist Expand / Collapse
Posted Tuesday, April 7, 2009 10:37 AM


Group: General Forum Members
Last Login: Thursday, March 21, 2013 11:17 AM
Points: 18, Visits: 51
I have log shipping going between two servers. The backup and restore jobs are working fine. But the alert job is throwing a fit (every two minutes) about two databases that no longer exist.

Is there a resyncing option? Or do I have to manually delete entries from the msdb.dbo.log_shipping_ in order to stop the error?

I'm new to log shipping, and easily distracted by shiny objects. Any help you can suggest would be appreciated.

Post #692279
Posted Tuesday, April 7, 2009 6:18 PM


Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Read about sp_delete_log_shipping_secondary at

Post #692665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse