November 28, 2011 at 8:29 pm
HI,
I am getting below error in secondary server,when they reboot the server.
14421 Error :
the log file could not be found that is too recent of file,
The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. No restore was performed for 40 minutes. Restored latency is 890 minutes.
Please anyone help me
Thanks
Jeri
November 28, 2011 at 11:22 pm
check with LSN number, what was the last copied LSN in secondary server, after that u need to copy all the log backups from primary and copy those in secondary server then re-run the restore job in secondary server.
November 28, 2011 at 11:43 pm
i checked, primary logs f0older contains 1450 log files, but in secondary server only (450 log files) why such log gap, i think server rebooted on secondary..?
November 29, 2011 at 12:03 am
It might be network problem or some other reasons,
as u said there was only 450 tran. logs in secondary. so just sort all the .trn files in modified date wise on both primary and secondary, then manually copy the .trn files from primary to secondary.
Then re run the jobs for log shipping.
November 29, 2011 at 12:09 am
what will i do, copy the all log files from primary to sencondary server then re run the restore job Right?
November 29, 2011 at 12:11 am
I got information from client , they rebooted the server on secondary..
November 29, 2011 at 12:18 am
yes u need to copy all the .trn files which were not copied to secondary server.
November 29, 2011 at 12:24 am
Ok .I will do.. Many thanks
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply