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
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.
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 "