Can't see any transaction after full restore

[dandrade]

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);

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521