Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, April 7, 2009 10:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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 http://msdn.microsoft.com/en-us/library/aa933265(SQL.80).aspx

MJ
Post #692665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse