Can't see any transaction after full restore

Undo for SQL Server.

Moderator: eddie davis

Can't see any transaction after full restore

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

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

Here is what he runs everyday:

BACKUP LOG my_db WITH TRUNCATE_ONLY; DBCC SHRINKFILE(my_db_log, 2000);
dandrade
 
Posts: 6
Joined: Sun Sep 30, 2007 1:52 am

Postby Brian Donahue » Tue Oct 16, 2007 12:43 pm

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: 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 1 guest