No transactions are recorded in the database log
AJURY
Posts: 2
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?
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
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.