SQL Server Performance Forum – Threads Archive
Log shipping generating error 14420Greetings, I am running SQL Server 2000 SP4. I have log shipping configured and it appears to be working. We see changes to the primary propagated to the standby. The monitor is on the standby server. However the monitor is showing out of sync and when I look at the sql server logs on the standby server the message pair The log shipping source (LOCAL).dbname has not been backed up for nnnn minutes
Error: 14420, Severity 16, State:1 is generated once per minute and every 30 minutes, when the database is scheduled to be backed up the log indicates it was backed up. The Backup Delta, Copy Delta load delta are constantly incrementing rather than being reset to zero and the value for the copy delta is consistent with the number of minutes displayed in the above error. I have looked at KB articles 329133 and 810969. Based on KB article 329133 I guess it has something to do with my backup alert threshold. It is set to 90 minutes and 14420 is enabled. My backups are schduled every 30 minutes. KB article 810969 indicates that the workaround is to use windows authentication in the specify the log shipping monitor server information dialogue box, which I did. I am guessing these are merely informational messages but nevertheless, I don’t understand what is happening and am hoping someone can explain it to me. Thanks.
May refer to the relevant topics:
http://www.sql-server-performance.com/forum/topic.asp?whichpage=-1&TOPIC_ID=5202&REPLY_ID=28629 Also refer to this Technet articlehttp://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx on LS information and those errors. HTH Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.