SQL Server Performance

Restore job skipping the logs on secondary server on SQL 2005!!

Discussion in 'SQL Server 2005 Log Shipping' started by jag_techie, Feb 6, 2009.

  1. jag_techie New Member

    i have a prod server from where i setup logshipping to 2 different servers. On one secondary server it is restoring the log files just fine but on the other server it keeps skipping the log files. the error message is shown below.
    i have tried removing logshipping, removing trn files on secondary server and dropped the db on secondary server. then i took back up of db again on primary server and restored it on secondary server and then added this secondary server on the logshipping setup again. But the restore jobs shows success as status but keeps skipping the logs and says could not find the right log to restore. YEs, i did not remove the whole logshipping though as on the other secondary server the restores are running fine. copy jobs on both secondary server are running fine though as it copies the log files on both secondary servers. there is no monitor server used. i have tried keep the logshipping intact and took fresh back up and restored on secondary server too but still it does not work. the message is :
    Step Name Log shipping restore log job step.
    Duration 00:00:35
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0
    2009-02-06 19:00:36.21 Skipped log backup file. Secondary DB: 'Personalization', File: '\CHEXSQCHNRT05d$NRT05File1 ranPersonalizationPersonalization_20090207025530.trn'
    2009-02-06 19:00:36.22 Skipped log backup file. Secondary DB: 'Personalization', File: '\CHEXSQCHNRT05d$NRT05File1 ranPersonalizationPersonalization_20090207030030.trn'
    2009-02-06 19:00:36.24 Could not find a log backup file that could be applied to secondary database 'Personalization'.
    2009-02-06 19:00:36.24 The restore operation was successful. Secondary Database: 'Personalization', Number of log backup files restored: 0
    2009-02-06 19:00:36.24 Deleting old log backup files. Primary Database: 'Personalization'
    2009-02-06 19:00:36.30 The restore operation was successful. Secondary ID: 'b6470874-1bb4-463d-ab9e-060a43393920'
    2009-02-06 19:00:36.30 ----- END OF TRANSACTION LOG RESTORE -----
    These are all on SQL 2005.
    I would appreciate if some one can help me out quickly as i need to get it fixed ASAP.
  2. satya Moderator

    Do not duplicate the thread in different forums, check the reply on other post.

Share This Page