Can't see any transaction after full restore

dandradedandrade Posts: 10
edited October 16, 2007 7:43AM in SQL Log Rescue
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);

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.