No transactions are recorded in the database log

Undo for SQL Server.

No transactions are recorded in the database log

Postby AJURY » Mon Jul 21, 2008 6:11 pm


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?
Posts: 1
Joined: Mon Jul 21, 2008 5:59 pm

Postby Brian Donahue » Tue Jul 22, 2008 12:34 pm


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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests