I have faced the same issue, resolved it by reapplying the Service Pack. 🙂

Please go through this link

http://support.microsoft.com/kb/925976

------

As mentioned in the above link..

1) Download the Pstools from the below link

http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx

2) Copy it to the server and from command...

Thanks for ur reply.

It worked.

We are facing the same alert agian.

The restore job is working fine, but we are getting the alerts.

Please find the error message.

The log shipping secondary database server_name.db_name has restore threshold...

Again LS_alert job is generating the alerts after reconfiguring the log shipping.

Please find the below error message.

Error: 14421, Severity: 16, State: 1.2009-04-08 11:26:00.05 spid53

The log shipping secondary database XXXXXXXXXX.DBNAME...

Since it is an urgent production issue, we have reconfigured logshipping in the box.

And log shipping configuration is successfull.

We found LS-Alert job is generating alerts for every 2 minutes.

Could you...

Thanks for ur help