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.

Does the sql agent account have the appropriate permissions to the folder where the backup files are being shipped to?
1 Like 1 ·
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 ·
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 ·
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 ·
I have done it already but still the same
0 Likes 0 ·
Show more comments

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.