Can't see any transaction after full restore

Undo for SQL Server.

Can't see any transaction after full restore

Postby dandrade » Sun Sep 30, 2007 12:55 am

Our network administrator has a scheduled job, is this the cause?

Here is what he runs everyday:

Posts: 6
Joined: Sun Sep 30, 2007 12:52 am

Postby Brian Donahue » Tue Oct 16, 2007 11:43 am

Thanks for posting. I think this is the cause of the problem, yes. If the log had been truncated, then there are no 'active' transactions to analyze. If you find yourself in this situation, including any transaction log backups in the list of backup files that the new project wizard asks for will help. The transactions that have been backed up will appear in the Log Rescue results, provided you have log backups available all the way back to the specified full backup.
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