LogShipping LSN Error
Everyday i keep receiving the following flavoured message regarding logshipping failing to restore. I understand partly why this is happening and how to fix it but i dont understand why it only happens once or twice a day.
02/02/2010 11:04:01: SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally. 02/02/2010 11:04:01: SQL error 4305: SQL error 4305: The log in this backup set begins at LSN 106965000007070200001, which is too recent to apply to the database. An earlier log backup that includes LSN 106965000007068900001 can be restored.
I currently have two SQL Backup jobs running which backups the transaction logs:
- Logshipping which takes a backup every 5 minutes
- Transaction Log which takes a backup every hour
Most of the time, both jobs run perfect but on the odd occasion, i get the above message and i have to restore the log from my hourly backup before LogShipping can resume restoring.
I have checked the LSN numbers on the backups taken by the transaction log job and both the first and last LSN numbers are the same on most backups except where it causes the logshipping to fail.
Is there anyway i can run both these jobs together? Can i prevent the hourly transactional job from breaking the logshipping without disabling or removing the job? and why does the LSN on the hourly transaction increase randomly? I was unable to find my answer on the forum here so i am hoping someone might be able to help.