No transactions are recorded in the database log

Undo for SQL Server.

Moderator: eddie davis

No transactions are recorded in the database log

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

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

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

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


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests