Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

RESTORE Problem in log shipping Expand / Collapse
Posted Saturday, November 30, 2013 11:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 8, 2015 7:00 AM
Points: 277, Visits: 71

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
Post #1518654
Posted Saturday, November 30, 2013 5:05 PM


Group: General Forum Members
Last Login: Thursday, October 20, 2016 2:00 PM
Points: 6,147, Visits: 13,677
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.


Post #1518666
Posted Sunday, December 1, 2013 1:57 PM



Group: Administrators
Last Login: Yesterday @ 7:48 AM
Points: 34,254, Visits: 18,436
I think George has the right idea here. Find the t-log backup or re-initialize with a new full backup.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1518709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse