question

rameshvgnr avatar image
rameshvgnr asked

SQl logshipping out of sync error

I have MSSQL server 2008R2 , configured log shipping. but backup,copy,restore successful. but alert at primary and monitor instance says, out of sync error 14421. i have schedule of 15 min set for all 3 jobs. and alert set for 3times=45 mins. but stil error please suggest what to do, it is troubling my life
log-shippinglogshippingsql 2008r2
1 comment
10 |1200

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

This web site runs based on your votes. Please indicate all the helpful answers below by clicking on the thumbs up next to them. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
0 Likes 0 ·
JohnSterrett avatar image
JohnSterrett answered
You need to look at the individual steps of the copy and restore jobs. While the jobs will complete successfully this will give you more details towards what is causing your alerts. Also, a very common problem I see with Log Shipping is the fact that DBA's don't disable log backups on the primary server where Log Shipping is configured. The transactional log backups have to be restored in order. If you have a log backup outside of log shipping they need to also be restored in sync.
10 |1200

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

NeerajTripathi avatar image
NeerajTripathi answered
It does happen when the log file that need to be restored are bigger in size and their work file is big. Analyse it properly and then increase the time for reporting the out of sync error. To make the restore fast, try to run the restore after changing the secondary database from standby to norecovery in case standby used. http://troubleshootingsql.com/2012/09/11/get-your-log-shipping-restore-to-run-faster/#
10 |1200

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

Chalapathi2205 avatar image
Chalapathi2205 answered
Dear Ramesh, When i started my carrier i faced same error. First you need to check at secondary server side .tuf file is generating or not after showing the Restoration job success. if tuf file is not generated then you should do the some changes in any one table in primary database then you run sequentially the backup job,copy job and finally restore job. once you complete this absolutely it will synchronize on both sides. if you want to know about 14421 error click here " https://msdn.microsoft.com/en-us/library/aa337265.aspx"
10 |1200

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

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.