Friday, February 24, 2012

Log Shipping Alert Firing for database that no longer exists

I have an error 14421 (database has restore threshold for 45 minutes and has not restored in more than "so many" minutes)firing for a database that no longer exists. How can I remove this alert? I have other log shipping plans that are running and so I can't delete the Log shipping alert job.Okay - that was too easy - I've struggled with this for 2 days - ran a select on the table in msdb - found the row that was screwy, and deleted .... now all is fine. Gotta use that tsql every once in a while!

No comments:

Post a Comment