RESTORE Problem in log shipping

  • Hi All,

    I have restore Problem in Log Shipping, the copy job succeed but when i see the restore job status that time it showing restore succeed but no data is reflecting in secondary server,

    when i see the restore job history it was showing this message: Searching through log backup files for first log backup to restore secondary database. the secondary database could not found the log backup file. that could be applied to secondary database

    please help me

    Thanks & Regards

    Chalapathi pagidakula

  • you are missing a transaction log backup. If you can find it restore it manually then carry on, else you will need to start again from a full backup, or a differential if no more full backups have been taken since logshipping went out of synch.

    no need to recreate log shipping jobs , just pause them whilst you do the reinitialise of the secondary database.

    ---------------------------------------------------------------------

  • I think George has the right idea here. Find the t-log backup or re-initialize with a new full backup.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply