SQL Server Performance

Log shipping generating error 14420

Discussion in 'SQL Server Log Shipping' started by wjwagman, Mar 9, 2006.

  1. wjwagman New Member

    Greetings, 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.
  2. satya Moderator

    May refer to the relevant topics:
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11421
    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
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page