Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 6:06 AM
Points: 36, Visits: 32


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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:50 PM
Points: 5,971, Visits: 12,860
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, June 11, 2014 5:42 PM
Points: 33,007, Visits: 15,132
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