|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 10/29/2012 : 17:14:41
|
I have deleted the database, removed log shipping of the database and its respective job but the job still runs, the secondary server LSAlert_devwinsql4 job error
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. The log shipping secondary database DEVWINSQL4.RE7 has restore threshold of 45 minutes and is out of sync. No restore was performed for 5850 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed.
Why do I see the error message, if there is no job and database does not exist. I have also executed the following statements:
delete from msdb.dbo.log_shipping_primary_databases
delete from msdb.dbo.log_shipping_primary_secondaries
delete from msdb.dbo.log_shipping_monitor_primary
delete from msdb.dbo.log_shipping_monitor_history_detail
delete from msdb.dbo.log_shipping_monitor_error_detail
delete from msdb.dbo.log_shipping_monitor_alert |
|
How to delete old log shipping jobs
