No transactions are recorded in the database log

AJURYAJURY Posts: 2
edited July 22, 2008 8:34AM in SQL Log Rescue
Hello,

I'm attempting to scan transactions from a full backup. But each time a load the back into a non production server I get the following error at the end. The process reaches about 93% and then it throws this error.

Is there something I'm missing?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    I don't have anything to suggest other than that the log (LDF file) does not contain any recoverable transactions, or that the full backup was taken after the final transaction recorded in the log. I guess you could try an earlier full backup as one option. The log file may have also been truncated and/or shrunk.
Sign In or Register to comment.