While restoring a database, which was damaged due to hardware failure. I Got the following Error Message,
"The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database RESTORE LOG is terminating abnormally"
Let me describe the Backup plan and effects after hardware failure.
Database Recovery Model : - FULL
Once in a month Complete Backup
Every day when sql server agent starts Differential Backup.
Transaction Log Starts 10.00 am and repeats every 20 minutes.
No problem with MDF File but CRC check failure for LDF file, The Database went suspect when sql server started. I ran DBCC cehckdb with 0 consistency errors.
I started restoring the database, I could restore the database from Last Complete backup to last Differential backup . While restoring the transactional log I got the above mentioned error.
Since the database is very crucial I need Help to restore these Transactional log backups.
Thanks in advance