question

munnast avatar image
munnast asked

Logshipping issue 2005 to 2014 in no recovery mode

all the jobs are running successful but the restore job is showing following message Skipped log backup file. Secondary DB: '5T', File: 'F:\SecondaryShared\5T_20160422144001.trn' 2016-04-22 09:48:01.97 Could not find a log backup file that could be applied to secondary database '5T'. 2016-04-22 09:48:01.97 The restore operation was successful. Secondary Database: '5T', Number of log backup files restored: 0 2016-04-22 09:48:01.98 Deleting old log backup files. Primary Database: '5T' 2016-04-22 09:48:01.98 The restore operation was successful. Secondary ID: '603bba1a-f150-4acf-a994-da5763fc0436'
sql-server-2005dbalogshipping
9 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Does the sql agent account have the appropriate permissions to the folder where the backup files are being shipped to?
1 Like 1 ·
munnast avatar image munnast commented ·
yes, they have full control to the folder, t-log files are been shipped to secondary folder the only issue is it is unable to restore it. when I manually tried to restore the log file it is throwing an error lsn is so earlier to apply.there is a brake in LSN
1 Like 1 ·
JohnM avatar image JohnM commented ·
If the log shipping is now in sync and that backup file is from prior to the differential then you should be able to remove it from the folder and error would go away. Or to make things cleaner, you can stop the jobs, clear the destination folder (I'd copy them somewhere for safe keeping), take a differential, restore it, and then resume the jobs.
1 Like 1 ·
JohnM avatar image JohnM commented ·
Sounds like it's out of sync. Can you take a differential of the primary, restore it to the secondary and then resume the backup jobs?
0 Likes 0 ·
munnast avatar image munnast commented ·
I have done it already but still the same
0 Likes 0 ·
JohnM avatar image JohnM commented ·
When you did that, did you clear out the destination folder before resuming log shipping?
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Have you checked to confirm that log shipping is out of sync?
0 Likes 0 ·
munnast avatar image munnast commented ·
No I didn't clear the destination folder
0 Likes 0 ·
munnast avatar image munnast commented ·
Thank you John
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.