Log shipping alerting on databases that no longer exist

  • 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.

  • Read about sp_delete_log_shipping_secondary at http://msdn.microsoft.com/en-us/library/aa933265(SQL.80).aspx

    MJ

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply