2

Here is the situation. I have restored a database to replace an existing version (need to get it back to yesterday at a certain time). So I do a RESTORE DATABASE ... WITH NORECOVERY, REPLACE, etc... with no problem.

There are about 16 transaction logs that I need to then restore as well to get the database to the point in time that I need it. The first RESTORE LOG completes with success. The second one tells me 100% complete, but immediately after that I get this message:

An error occurred while processing the log for database 'MyDb'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

What exactly does this mean?? I did some research and it looks like a few things can cause this, and none of the examples/situations I read about had to do with a RESTORE LOG. Does this possibly mean my transaction log backup is corrupt??

Is there any remedy to this?

2

Sounds like the data in the log backup might have been corrupted. Can you restore the next log ok, or do you get an error at that point as well?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy